calculating daily totals

Hi folks, I have a table with 5 years of data containing 16k+ rows. It's organised from top to bottom in date order. Each day however comprises a different number of rows. There are no blank rows between each date. I would like to calculate the individual daily totals but cannot find a way to do this. Does anybody know of a way to do this other than manually? Any help would be gratefully received.

Best wishes

Andy

Originally Posted by Tony Valko

If you have a list of the unique dates then you can do this...

Dates in column A
Values to sum in column B
List of unique dates starting in cell D2 downwards

This formula entered in E2 and copied down:

=SUMIF(A:A,D2,B:B)

You can generate the list of unique dates easily using advanced filter:

http://contextures.com/xladvfilter01.html#FilterUR

My God Tony, that was quick and worked perfectly. Many thanks for sharing your expertise.

Best wishes

Andy