Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count By Date Need Some Help
Ok, I have a Work Book with 3 Sheets. The first sheet at dates in Column A
(2-Feb-2007), the second has serial numbers and the third Column C has the number of items on hand. What I am trying to do is if the serial number has a date of a month (ie 1-Jan-2007) then i would like to sum the number of items on hand for each month. The first sheet currently looks like this 2-Feb-2007 37220 41 7-Feb-2007 37247 48 8-Feb-2007 37255 115 9-Feb-2007 37267 104 The data will be summed on the third sheet. And should look like this. Month # Serial # Items Selected Jan Feb Mar Ect.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count By Date Need Some Help
=SUMPRODUCT(--(ISNUMBER(A2:A100)),--(MONTH(A2:A100)=1),C2:C100)
will sum C for month of January any year =SUMPRODUCT(--(ISNUMBER(A2:A100)),--(MONTH(A2:A100)=1),--(YEAR(A2:A100)=2007),C2:C100) for Jan 2007 -- Regards, Peo Sjoblom "Terry" wrote in message ... Ok, I have a Work Book with 3 Sheets. The first sheet at dates in Column A (2-Feb-2007), the second has serial numbers and the third Column C has the number of items on hand. What I am trying to do is if the serial number has a date of a month (ie 1-Jan-2007) then i would like to sum the number of items on hand for each month. The first sheet currently looks like this 2-Feb-2007 37220 41 7-Feb-2007 37247 48 8-Feb-2007 37255 115 9-Feb-2007 37267 104 The data will be summed on the third sheet. And should look like this. Month # Serial # Items Selected Jan Feb Mar Ect.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
count the mean in few date but on de date it has various data | Excel Worksheet Functions | |||
count between start date and end date | Excel Discussion (Misc queries) | |||
Count number of cells with date <today's date | New Users to Excel | |||
count the number of cells with a date <= today's date | New Users to Excel |