Thanks Biff. You brought out a good point about duplicate lows.

"Biff" wrote:

What if there are duplicate lowest numbers? Do you want to exclude all of
them or just one of them?

This will exclude just one of them:

=SUM(A1:A10,-MIN(A1:A10))/(COUNT(A1:A10)-1)

Biff

"inspiredtoo" wrote in message
...
How can I calculate averages automatically subtracting the lowest number
in a
range?
I was told to use the SUM, MIN and Count function
Thanks