| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Records Between Two Dates
Hi,
I have a long list of records all on the same worksheet. In column d are the categories I want to search on (e.g. apples). I am tryoing to found out how many apples between 01/01/2008 and 31/01/2008. I have tried =SUMPRODUCT((D1:D999)=1/1/2008)*((D1:D999)<=31/12/2008)*(G1:G999="apples") This returns 0 even though there are apples in column g between these dates. Can somebody please help? Best regards Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting records f(x) two columns | Excel Discussion (Misc queries) | |||
| Help a novice with counting number of records | Excel Discussion (Misc queries) | |||
| counting records | Excel Worksheet Functions | |||
| Counting unique records | Excel Worksheet Functions | |||
| Counting records within a month | New Users to Excel | |||
Threaded Mode
