COUNTIF Help

[Rollin_Again]

How can I use COUNTIF to determine how many cells in a range contai
numeric values. I have range of cells that have either a number i
them or the text "n/a" I want to count the cells in the range wit
only the numbers and not n/a.


Rolli

 

[Domenic]

Hi,

Try...

=COUNTIF(A1:A10,">0")

Hope this helps!

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(ISNUMBER(A1:A100)))

 

[Rog]

Rollin, you may find the COUNT function does what you
want - it only counts numeric values

Rgds

Rog