Countif and Isnumber in a range

  • Thread starter Thread starter Commish
  • Start date Start date
C

Commish

I am trying to query a range of cells to find out how many of them are
numbers - there are also null, text, and errors (#N/A) values mixed
in.

I tried to use this: {=countif(BR3:BR100,isnumber(BR3:BR100))}

And of course this didn't work, did I even get close? Is there a
function that I can use to make this work? How come the "IF" part of
Countif and Sumif isn't more robust? Or do I just need to be more
robust?

Thanks.
 
I am trying to query a range of cells to find out how many of them are
numbers - there are also null, text, and errors (#N/A) values mixed
in.

I tried to use this:     {=countif(BR3:BR100,isnumber(BR3:BR100))}

And of course this didn't work, did I even get close? Is there a
function that I can use to make this work? How come the "IF" part of
Countif and Sumif isn't more robust? Or do I just need to be more
robust?

Thanks.
Click to expand...

I should add that I know I can just do =Count(Br3:br100) to get the
answer in this case....

But is there away to get a logic/function check within the countif?
 
Try this:

=COUNTIF(BR3:BR100,"<1E100")

--
Biff
Microsoft Excel MVP


I am trying to query a range of cells to find out how many of them are
numbers - there are also null, text, and errors (#N/A) values mixed
in.

I tried to use this: {=countif(BR3:BR100,isnumber(BR3:BR100))}

And of course this didn't work, did I even get close? Is there a
function that I can use to make this work? How come the "IF" part of
Countif and Sumif isn't more robust? Or do I just need to be more
robust?

Thanks.
Click to expand...

I should add that I know I can just do =Count(Br3:br100) to get the
answer in this case....

But is there away to get a logic/function check within the countif?
 
Back
Top