COUNTIF Help

Rollin_Again · Aug 11, 2004

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 · Aug 11, 2004

Hi,

Try...

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

Hope this helps!

Frank Kabel · Aug 11, 2004

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

Rog · Aug 11, 2004

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

Rgds

Rog

COUNTIF Help

Rollin_Again

Domenic

Frank Kabel

Rog