Thread: Countif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Countif

try

=COUNT(A1:A100)

Mike

"PK" wrote:

I am trying to count the number of cells that have a number in it. I would
suspect that the COUNTIF function would be the one but how can I get to count
only if the cell contains a number (the numbers will all be different)
--
pk