asked on calculate cells to one field using a formula. Calculate total in field divided by number of fields
I have attached an excel spreadsheet.
Basically I need to take only the values that are filled out in the blue section, add them up, and then divide them by the number of fields that had a value in it.
For example.
Since there are 7 fields in blue that were filled out, then the result in the yellow field at the bottom of the sheet would be 20 / 7 = result
How can I have a formula that would calculate this complex solution? HELP!
sample.xlsx
Basically I need to take only the values that are filled out in the blue section, add them up, and then divide them by the number of fields that had a value in it.
For example.
Since there are 7 fields in blue that were filled out, then the result in the yellow field at the bottom of the sheet would be 20 / 7 = result
How can I have a formula that would calculate this complex solution? HELP!
sample.xlsx
Microsoft Excel
Last Comment
Rob Henson
Have you tried using the Average function? It will allow for multiple ranges.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
What if I want to specify over two ranges as seen in the attached sheet?
Barry's solution covers the whole range from B to E so includes both ranges. The columns in between will be ignored because they are text or blank.
If the columns in between may get numbers then you can put multiple ranges into the Average formula:
=AVERAGE(B7:B32,E7:E32)
Thanks
Rob H
If the columns in between may get numbers then you can put multiple ranges into the Average formula:
=AVERAGE(B7:B32,E7:E32)
Thanks
Rob H