need formula for # names listed * $5

G

Guest

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
 
B

Bob Phillips

Do you mean

=COUNTA(A1:A30)*5

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
How do I include names in formula by picking up names from rows 6
Formula for adding 2 worksheets 1
a formula to search for names in columns and then add the figures 5
Return Names From List 2
Adding up total hours worked on employee schedule using various criteria 0
Need to Pull Those that Start with Letter P 2
SUMIF Help 4

Top