Sum cells in a range based between two equal cell values in another range

**sshone1** · 07-08-2013, 10:33 PM

I have three columns of data. The first is criteria that I am using to decide which cells to add in the other two cells as follows...

0 0 348
1 277 0
1 0 32
3 0 5
4 104 0
4 41 0
3 0 199
4 299 0
4 108 0
4 6 0

My problem is when I come to the first 3 I need to sum all other rows until I hit the next 3. Any help would be great. I have tried several versions of sumproduct and sumif but can not get it to work. I have attached clear sample data.

**elayaz** · 07-09-2013, 02:03 AM

Hi Welcome to the forum.

Thanks for giving us sample data, but unfortunately i didn't understand what you need as a final result.

Is this you are trying- Whenever the cell in B3 has number "3" you want to sum/add the above adjacent column d & e range (d2:e10).

It would be great, if you manually calculate the desired results in column F ( for the sample data) and re-upload.

Thanks

**sshone1** · 07-09-2013, 08:12 AM

Elayaz.

Attached is a clearer example... This structure is a parent/child relationship. I am having trouble getting it to see a child that has children of its own to add those but stop at the next child of equal level.

Book1-2.xlsx