count cells that have something in it

[Guest]

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

 

[Sandy Mann]

=COUNTA(A1:A8)

for *something* in a cell

=COUNT(A1:A8)

to count only numbers in cell even if there is also text in some cells

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

Look at COUNTA function.

 

[Guest]

Hi,

try this:

=COUNTA(A1:A19)

if you want to count just numbers try this:

=COUNT(A1:A19)

Thanks,

 

[Guest]

=COUNTIF(A1:A8,"<>""")

 

[Ron Coderre]

If your example is accurate and you only want to count the non-blank cells
in A1, A4, A7 and A8...
Try this:
=COUNTA(A1,A4,A7:A8)

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)