Using countif and isnumber

A

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
 
A

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.
 
D

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top