=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