formula for percent average(s)

  • Thread starter Thread starter jn
  • Start date Start date
J

jn

I have four columns (a1:d1) that list numbers, with the
sum listed in e1. I need e1 to not only sum a1:d1, but to
divide it by the number of actual inputs, i.e. if a1 and
c1 are the only ones with numbers, sum/2. If all (a1:d1)
have numbers, sum/4. Any help will be greatly
appreciated.
 
You must log in or register to reply here.

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

Different cells that need to sum in one 4
How to copy the function SUM but offseted in 7 columns 2
Nested IF statement 3
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA 3
SUM of a row of formulas 13
How to set cell value to emptry if three other columns are empty too 1
Simple Average ? 3
Error when using Sum command 3

Back
Top