COUNTIF cannot count decimal number occurences
 

Excel function COUNTIF cannot count decimal number occurences in an array.
Why? What to do?
Thanks

COUNTIF cannot count decimal number occurences
 

try something like:

=COUNTA(A1:A7)-COUNTIF(A1:A7,"-99^99")

where A1 thru A7 contain:
1
2
3
4
a
b
cd


will return 4 the number of numbers rather than text

--
Gary''s Student
gsnu200702


"Ignorasmus" wrote:

Excel function COUNTIF cannot count decimal number occurences in an array.
Why? What to do?
Thanks

COUNTIF cannot count decimal number occurences
 

Maybe you could just use:

=count(a1:a10)
to count the number of numbers.



Ignorasmus wrote:

Excel function COUNTIF cannot count decimal number occurences in an array.
Why? What to do?
Thanks

--

Dave Peterson