Countif and Isnumber in a range

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

 

[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 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?

 

[T. Valko]

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.

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?