Sum Cells within each date.

D

DJC

Hi, I have a spreadsheet with all sales for a given month.I wish to seperate
this into Days for accounting.

IE
1/10/05 Mr Smith £65.56
1/10/05 Mr Crisps £34.56
2/10/05 Mr Eat £21.34
and so on..
I would like to see a breakdown of days
IE
1/10/05 £100.12
2/10/05 £21.34
Is this possible
Thankyou in advance
 
B

Bob Phillips

Assuming test date is in M1, use

=SUMIF(A:A,M1,C:C)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top