M
mokihi
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
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