How can i sum up numbers which are counted on a date.
Just one more thing, when i say it is summarized by dates i mean on sheet 3 i
have a list Jan
Feb
Mar ect... so then for each month in column b i need to know how
many items were counted on sheet 1
"Terry" wrote:
Hi everyone thanks for the help, I should have been more clear on what I was
actually doing.
Darren your comment was more like the actuall workbook.
Column A on Sheet 1 is dates ie 14-Jan-2007 Column B is the Number I need to
count.
This is then summarized by dates on sheet 3 and i need a seperate formula
for each month then to count the number of items within each date.
So how would i find values within the month rather then based on the title
ie ' October ' For example
"Darren Bartrup" wrote:
I'm making a couple of assumptions he
If you've got details of your items in column B, with the relevant dates in
column A
(cells A1:B7):
01/02/2007 3
01/02/2007 8
01/02/2007 2
01/05/2007 1
01/05/2007 5
01/06/2007 3
01/06/2007 6
Then in column D you've got a list of unique months
(cells D1:D3):
01/02/2007
01/05/2007
01/06/2007
You could use the following formula in cell E1 to give you a sum of items
appearing in each month:
{=SUM(IF(D1=$A$1:$A$7,$B$1:$B$7))}
This has to be entered as an array formula - press Ctrl~Shift~Enter instead
of just Enter when completing the formula. Drag this down from E1 to E3 for
your totals on each month.
Regards,
|