I am trying to find an average percentage score of 6 different numbers, but I want to delete the MIN and MAX number included in the Array.
For example This is my data set: imgur.com/a/0xvRjae
In row 29 i put the formula: =(SUM(H29:M29)-MAX(H29:M29)-MIN(H29:M29))/100
That came out to a value of 0.34, which is the desired number I wanted.
But in 32 and 34, the values come out wrong (one as a negative value, which it should never go below 0). It doesn't include 0 in the formula. I want to know how to include 0 as a minimum number in the calculation.
Bookmarks