So I have a nice simple spreadsheet, and I want to calculate the averages of several derived percentage values. However, in some cases the percentage is over 100%.
What I want to do is calculate the real average - discarding any value over 100%. For (very simple) example:
The "average" of these three values is:
(120%+80%+100%)/3 = 100%
The *real* average of these values should be:
(120%+80%+100%)/3 = 93.33%
There must be a function in Excel to do this, and I'm reasonably certain it's easy. I'm just not finding it in the help dox, most likely because I'm not sure of the name of the action I'm looking for.