Thread: Countif
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Countif

COUNT function counts numbers only.

COUNTA functions counts non-blank cells.


Gord Dibben MS Excel MVP

On Sat, 17 Nov 2007 02:46:00 -0800, 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)