count cells that have something in it
 

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

count cells that have something in it
 

=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


Replace @mailinator.com with @tiscali.co.uk


"delete automatically" wrote
in message ...
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

count cells that have something in it
 

Look at COUNTA function.

"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

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

count cells that have something in it
 

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

"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

count cells that have something in it
 

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)

"delete automatically" wrote
in message ...
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