| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show if between two dates
Hi everyone
I am trying to count that if the name in T21 is anywhere in column D and the corresponding cell in column A is between the 01/01/2010 and the 31/01/2010 I have written the following but its not working - where am I falling down please? =SUMPRODUCT(($D$2:$D$618=T21)*($A$2:$A$618=01/01/2010,<31/01/2010)) Thanks as always Lise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show data between two dates? | Excel Discussion (Misc queries) | |||
| Show only future Dates | Excel Worksheet Functions | |||
| Dates won't show? | Excel Discussion (Misc queries) | |||
| HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? | Excel Worksheet Functions | |||
| HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? | Excel Discussion (Misc queries) | |||
Threaded Mode
