Organise totals by date

[paulfitz320]

A B
01/01/07 10
01/01/07 11
01/01/07 12
02/01/07 15
02/01/07 16
02/01/07 17
I need to add these figures in B and group the totals by date in A eg, 01/01/07 33 in C

Thanks

 

[Oaktree]

Sounds like a job for a pivot table

 

[paulfitz320]

yep, sorted it out with a pivot

Thanks