Using countif and isnumber

[Aaron]

I am trying to count the number of cells that have a number, instead
of a blank or an na(). Here is what I tried,
=COUNTIF(B6:B1489,ISNUMBER(B6:B1489)) This doesn't work, anyone have
a solution?

Thanks,
Aaron

 

[Ken Wright]

=COUNT(B6:B1489)

 

[Aaron]

If I just use the regular count formula it includes cells which
contain #n/a. I do not want to include those in my count. I only
want to include cells with numbers.

For instance:
cell a1 = 3.2
cell a2 = #n/a
cell a3 = 4.3

When I count the cells I want the value to be 2. The regular count
i.e. =count(a1:a3) will return 3. Thanks again.

 

[Dave Peterson]

You sure you didn't type:

=countA(a1:a3)
(note that extra A)


I get 2 with =count(a1:a3)
with your data.

 

[Jerry W. Lewis]

What version of Excel are you using? Every version I am familiar with
will return 2, not 3 for the data you describe.

Jerry