Count number of entries within a specific date range

Hi everyone,

In column A, I have a range of dates. In column C, some cells are blank and some contain numerical values.

I'm trying to count the number of cells in column C within each month which are not blank and have a value greater than 0.

It sounds simple, but I can't get it to work for some reason. I've attached an example and hopefully someone can suggest a way to make this work....

Andy

H2=COUNTIFS($A$2:$A$17,">="&$F2,$A$2:$A$17,"<="&$G2,$C$2:$C$17,">0",$C$2:$C$17,"<>") copy down

I've always found SUMPRODUCT to be easier
=SUMPRODUCT($A$2:$A$17<=$G2,$A$2:$A$17>=$F2,$C$2:$C$17>0)

Thank you for your input.

+CARACALLA - the COUNTIFS formula worked great.

+Pepe Le Mokko - the SUMPRODUCT formula gave me a 0 result in each cell for some reason.

Does it return 0 when you open the attached?

Yes, it does still return 0.