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.
Bookmarks