countif with date range

[MASHED_33]

Hi,

I'm trying to count the Excellent and Very Good "Status" from range Jan. 27 to Feb. 3; I tried a simple function =SUMPRODUCT(--(AW27:AW45<"02/02/2011"+0),--(AB27:AB45="Very Good")) to just compute Very Good before Feb. 2, but it only returns zero.

I have just also tried counting Dates before Feb. 2 [=COUNTIFS(AW27:AW45,"<=$AW$30")], just to decipher what code should I use but also returns zero.




Status Date

Good 27/01/2011
Very Good 27/01/2011
Excellent 27/01/2011
Very Good 02/02/2011
Excellent 03/02/2011
Excellent 10/02/2011

Appreciate anyone's help on this. I'm using Office 2007

 

[MASHED_33]

Hi Guys,

Thanks for all your help. COUNTIFS and SUMPRODUCT would work on this just as easy as that, the issue is that the contents of the table has a different format or may be it's protected.

After I copied the Table and paste it as value, I ran COUNTIFS and SUMPRODUCT at the same time and this time it works.

Thanks again!!!