Thread: Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William Benson William Benson is offline
external usenet poster
 
Posts: 121
Default 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)