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
Microsoft Excel
Last Comment
Rob Henson
8/22/2022 - Mon
Shaun Kline
Have you tried using the Average function? It will allow for multiple ranges.