#### hatahetahmad

##### New Member

- Joined
- Jan 8, 2016

- Messages
- 31

Hello, I have very simple data, that I want to group by SUM

As the uploaded image shows. My Data has 3 columns, first comes Index, Numbers then Group, which I want to fill according to specific limit cell H2.

I started by summing like cumulative column, then divided the result by the limit and rounded up to 0 decimals.

It showed me groups but some groups have more than the limit, therefor incorrect solution.

Results should be: Cell C2 and C3 should show 1 , Cell C4 should show 2 , Cell C5 and C6 should show 3 , Cell C7 and C8 should show 4 , Cell C9 should show 5 ...

The Idea is straight but not simple to execute.

I'm open to any solution using Excel Formulas, DAX or M

You can download the file from here

Please advise me.

Many Many Thanks

As the uploaded image shows. My Data has 3 columns, first comes Index, Numbers then Group, which I want to fill according to specific limit cell H2.

I started by summing like cumulative column, then divided the result by the limit and rounded up to 0 decimals.

It showed me groups but some groups have more than the limit, therefor incorrect solution.

Results should be: Cell C2 and C3 should show 1 , Cell C4 should show 2 , Cell C5 and C6 should show 3 , Cell C7 and C8 should show 4 , Cell C9 should show 5 ...

The Idea is straight but not simple to execute.

I'm open to any solution using Excel Formulas, DAX or M

You can download the file from here

### test group by sum.xlsx

drive.google.com

Please advise me.

Many Many Thanks