Sum Without MIN or MAX values

[Str|ker]

Hi,

Trying to work out the formula so a Sum of a column is calculated without the highest or lowest number in that column included.

Any help would be much apricated. Attached is what I've got to so far. After H31:K31 Results

Cheers

[protonLeah]

Maybe:

Please Login or Register  to view this content.

???

[Str|ker]

Thanks Ben that works to my expected totals.

Cheers

[SanjiVinsmoke]

=SUMIFS(H13:H17,H13:H17,"<"&MAX(H13:H17),H13:H17,">"&MIN(H13:H17))
=AVERAGEIFS(H13:H17,H13:H17,"<"&MAX(H13:H17),H13:H17,">"&MIN(H13:H17))

This helped me as well, I was trying to apply all the logic, Thank you for this, also I learnt while trying to solve this that in order to get average excluding the MIN and the MAX values, here is what we can use:

(SUM(A2:A12)-MIN(A2:A12)-MAX(A2:A12))/(COUNT(A2:A12)-2)

Cheers!