Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there
I want to count how many "Level 1" cells that are older than "3/9/08". My columns and rows look like this: A B Level 1 03/09/08 Level 2 04/11/07 Level 1 01/02/07 Level 1 31/03/08 Level 2 14/04/08 Level 4 16/09/06 Level 4 16/09/06 Can someone please give me the COUNTIF or SUMPRODUCT formula to calculate this. I don't have 2007 so COUNTIFS aren't an option for me. I have read through the other listings but can't seem to pinpoint a formula that works. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Two COUNTIFs | Excel Discussion (Misc queries) | |||
Countifs Fx in 07 how in 03? | Excel Discussion (Misc queries) | |||
How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
countifs | Excel Discussion (Misc queries) | |||
Format text 'dates' to real dates | Excel Worksheet Functions |