Repeated Summation of group of numbers in large number of data

[dimuthumme]

Hello
I want to get the summation for first 24 data, then next 24 data and so on as per the D column. I tried with =SUMIF(A2:A25, "<>0", C2:C25) equation. But it doesn't work. I know it is something similar to =IF(A2=0, AVERAGEIF(C2:C25, "<>0", C2:C25), "") format, which is used in E column to get the average value. But it is rather difficult to modify. Kindly help me. I hv attached the sheet.

[Pete_UK]

Put this in D2:

=IF(A2=0,SUMIF(A2:A25, "<>0", C2:C25),"")

then copy down. You might need to change the commas to semicolons.

Hope this helps.

Pete

[dimuthumme]

Hello Pete_UK
Great. It works. Thank You very much.

[Pete_UK]

Glad to hear it - thanks for feeding back, and for the Rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete