Averaging

[Stewart]

Example:
Sorry, I'm having difficulty with this one.
I have 4 numbers 5,5,10,20 and I want to drop the lowest
number and average the top 3.

Excel XP
Thanks

 

[Frank Kabel]

Hi
try
=(SUM(A1:A4)-MIN(A1:A4))/3
if A1:A4 store your 4 numbers