View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Counting cells that contain data

=COUNTA(range)

COUNT only counts numerics.


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 16:56:01 -0700, Karl wrote:

Hi,

I'm trying to use the count function to count the number of cells in a range
of cells which contain data. I can't figure out how to do it, can anyone help.

Thanks

Karl