Quote Originally Posted by TonyB51 View Post

If you have your data on Sheet 1 and use column A on say sheet 2 for the Dates then use a sumif in column B.
ie at B1 use =SUMIF(Sheet1!A:A,A1,Sheet1!B:B), then fill down against the dates.

Cheers

TonyB
Thanks Tony - testing this out now!

-kcr