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.
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!