Sum Cells within each date.
 

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

Sum Cells within each date.
 

Assuming test date is in M1, use

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DJC" wrote in message
...
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

Sum Cells within each date.
 

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


DJC wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html