View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default count cells that have something in it

Hi,

try this:

=COUNTA(A1:A19)

if you want to count just numbers try this:

=COUNT(A1:A19)

Thanks,
--
Farhad Hodjat


"delete automatically" wrote:

How do I count cells that have something in it? For example if A1,A4,A7,A8
has anything in it the I want cell A20 to say 4