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