Countif Isnumber(A1:A5) I thought that I mastered Countif function...wrong

Posted by Mark P. on June 04, 2000 6:48 PM

Am I in a bad day?!? I thought that's an easy one but I can't figure out how to make Countif to count the cells that are numbers in range A1:A5. I tried countif=(A1:A5,"isnumber(A1:A5)=true") as an array but nix.

A1=33, A2=-4, A3=Stock A4=Plan A5=0

The actual range is A1:A330 so I don't think that trying to use a nested If function instead of Countif is a manageable task. Thank you for your help.

Posted by Ivan Moala on June 04, 0100 8:42 PM

You could try this Array formula as follows;

{=SUM(IF(ISNUMBER(A1:A5)*ISNUMBER(A1:A5),1,0))}

or a Std formula;

=COUNTIF(A1:A5,">0")+COUNTIF(A1:A5,"&LT;0")+COUNTIF(A1:A5,"=0")

HTH

Ivan