G
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
has anything in it the I want cell A20 to say 4
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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
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
G
Guest
Look at COUNTA function.
G
Guest
Hi,
try this:
=COUNTA(A1:A19)
if you want to count just numbers try this:
=COUNT(A1:A19)
Thanks,
try this:
=COUNTA(A1:A19)
if you want to count just numbers try this:
=COUNT(A1:A19)
Thanks,
G
Guest
=COUNTIF(A1:A8,"<>""")
R
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)
in A1, A4, A7 and A8...
Try this:
=COUNTA(A1,A4,A7:A8)
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)