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

=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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"delete automatically" <(E-Mail Removed)> wrote
in message news:A9B28A3E-6C46-4D54-B1CC-(E-Mail Removed)...
> 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
>

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

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

=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

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" <(E-Mail Removed)> wrote
in message news:A9B28A3E-6C46-4D54-B1CC-(E-Mail Removed)...
> 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