Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating cells with date format | Excel Discussion (Misc queries) | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Format cells as date | Excel Discussion (Misc queries) | |||
Calculating current age from 2 date cells | Excel Worksheet Functions |