SUM values based on date

**dave_the_bear** · 08-15-2012, 08:28 AM

I have a Date field and a Values field and want to sum the values based on this and to start again for new dates?

eg.

VALUES DATE TOTAL
12 12/08/2012 39
13 12/08/2012 39
14 12/08/2012 39
14 13/08/2012 27
13 13/08/2012 27

Thanks

**NBVC** · 08-15-2012, 08:32 AM

Not sure if I exactly follow, but I think you are looking for SUMIFS

e.g.

=SUMIFS(C:C,A:A,X1,B:B,Y1)

where X1 holds value to find in column A, and Y1 contains date to find in column B, summing column C.

If you are looking for a date range

=SUMIFS(C:C,A:A,X1,B:B,">="&Y1,B:B,"<="&Z1) where Y1 and Z1 contain start/end dates to limit to.