Using countif and isnumber

  • Thread starter Thread starter Aaron
  • Start date Start date
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
 
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.
 
You sure you didn't type:

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


I get 2 with =count(a1:a3)
with your data.
 
What version of Excel are you using? Every version I am familiar with
will return 2, not 3 for the data you describe.

Jerry
 
Back
Top