ExcelBanter - Countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Countif (https://www.excelbanter.com/excel-programming/330984-countif.html)

William Benson

Countif

Hi,

I would like a formula that counts numerical items in a cell range ...
something which will not make me have to loop through the cell range. Any
way to use Countif for this?

For example:

Cell Value Isnumber
30 TRUE
TRUE FALSE
FALSE FALSE
3.3 TRUE
Three FALSE
FALSE (note: blank cell)

JE McGimpsey

Countif

How about

COUNT(A:A)

In article ,
"William Benson" wrote:

Hi,

I would like a formula that counts numerical items in a cell range ...
something which will not make me have to loop through the cell range. Any
way to use Countif for this?

For example:

Cell Value Isnumber
30 TRUE
TRUE FALSE
FALSE FALSE
3.3 TRUE
Three FALSE
FALSE (note: blank cell)

William Benson

Countif

Perfect, thanks!

"JE McGimpsey" wrote in message
...
How about

COUNT(A:A)

In article ,
"William Benson" wrote:

Hi,

I would like a formula that counts numerical items in a cell range ...
something which will not make me have to loop through the cell range. Any
way to use Countif for this?

For example:

Cell Value Isnumber
30 TRUE
TRUE FALSE
FALSE FALSE
3.3 TRUE
Three FALSE
FALSE (note: blank cell)

All times are GMT +1. The time now is 01:06 AM.