Sum Cells within each date.

[Guest]

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

 

[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)

 

[Debra Dalgleish]

You could use a pivot table to summarize the data by day. There are
instructions in Excel's Help, and Jon Peltier has instructions and links:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm