'How to ignore a ROW in Average function, set up by a Max function?
I will try my best to explain my dilemma; in Column B23:B37 is a list of numbers from which I would like to get the Average (Function - =AVERAGE(B23:B37)).
The problem is, the biggest number (B30 = 8.3) should not be counted in the Average function.
My solution to this, is =ARRAYFORMULA(AVERAGE(IF(B23:B37<>MAX(B23:B37);B23:B37)))
And the result you can see in the image = 1.73
The thing is, as you can see in de Column A (same list of number, just without the 8.3 number) equals 2.22 . I guess, that the real average, without the B30 Row.
My formula must be all wrong! how can I make this work?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|