Formula to drop the smallest number and average the rest

[Heather]

In Excel, if I have 4 cells with various values, and I want to drop the
smallest value, average the rest by giving the three remaining equal weight,
how do I write the formula? I've been unsuccesful so far.

 

[Dave Peterson]

I'd use:

=(SUM(A1:A4)-MIN(A1:A4))/(COUNT(A1:A4)-1)

 

[nh]

A couple of ways: -
Assuming the values are in Cells A1 thru A4 on cell A5 enter
=AVERAGE(IF(A1:A4<>MIN(A1:A4),A1:A4)) (array entered (Ctrl+Shift+enter)
Or
=(SUM(A1:A4)-MIN(A1:A4))/(COUNTA(A1:A4)-1)

 

[Biff]

Hi!

What if the lowest value occurs more than once?

Try one of these:

=(SUM(A11)-MIN(A11))/3

This is an array formula and must be entered with the key
combo of CTRL,SHIFT,ENTER:

=AVERAGE(IF(A11<>MIN(A11),A11))

Biff