Calculating Cumulative Totals

[ezzy85]

I am trying to calculate cumulative totals for some data and then graph them.
I have different groups and they get a score everyday. I want to be able to calculate the total scores for each group every month cumulatively.
I have started doing this on the attached spreadsheet but have reached a stumbling block. So far I have been able to get a cumulative score for the total each month, but I cant work out how to split it by the group numbers.
In my spreadsheet, it is working upto Cell G31. When it gets to group 2, it should reset and start cumulating from 0.

Sorry about the screenshot. I tried attaching the spreadsheet but for some reason it is 2MB.

Thanks

[shg]

If you want help with Excel, perhaps you should post a workbook instead of a picture.

[royUK]

As shg says attach a workbook, but maybe you should be using a PivotTable.

[ezzy85]

i tried posting the workbook but it for some reason was 2MB and exceeded the limit. But I tried this formula and a pivot table and it seems to be working:

=SUMIF($A$2:A2,A2,$B$2:B2)

thanks for your time guys.