Count Function

[Eric]

I am having trouble getting a formula to work properly.

I have to drop the lowest number and average the rest. F4
cannot show an error message if a cell is blank.

B4=10
C4=9
D4=1
E4=7
F4=average

The formula I tried is
=IF(B4="","",(sum(b4:e4)-MIN(b4:e4)/count(b4:e4)))
This returns a answer of 26.6667

If I insert AVERAGE before (sum...) I still get the same
answer. What am I doing wrong?

 

[Peo Sjoblom]

One way

=AVERAGE(LARGE(B7:E7,ROW(1:3)))

entered with ctrl + shift & enter

 

[Eric]

Thanks! It worked. Why do you have to enter with ctrl +
shift + enter? The first time I tried I only used enter
and it did not work properly.