# Finding Minimum Value INCLUDING 0

1. ## Finding Minimum Value INCLUDING 0

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.  Register To Reply

2. ## Re: Finding Minimum Value INCLUDING 0  Register To Reply

3. ## Re: Finding Minimum Value INCLUDING 0

That formula won't give you the average - you will need to divide by the number of cells which are contributing to the sum. Also, if you have two or more values which are maximum (or minimum), won't you want to disregard all those values?

Pete  Register To Reply