| 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.. |
| 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 | |||
Threaded Mode
