Do you mean

=COUNTA(A1:A30)*5

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"elleneII" wrote in message
...
I have one column, 30 lines. LINES WITH NAMES PAY $5. Need a formula that
will give include all thirty lines with names but only give a result for
the
lines with names. So that whenever names are added I won't have to redo
the
formula each time.
msexcel2003