Try this:

=SUM(C13:E13,-MIN(C13:E13))/MAX(COUNT(C13:E13)-1,1)

If all the cells are empty it will return 0.

--
Biff
Microsoft Excel MVP


"Naomi" wrote in message
...
No even if there is a duplicate minimum number grade only one needs to be
dropped

"T. Valko" wrote:

What if there is more than 1 instance of the minimum grade? Should each
minimum grade be excluded?

--
Biff
Microsoft Excel MVP


"Naomi" wrote in message
...
I have a formula that takes a array that includes number grades, drops
the
lowest grade and averages them. If there is no data in cell yet i get
a
#DIV/0! error is there a way to copy this formula to following cells
without
data in them yet and not get this error. The formula Im using is:
=AVERAGE(IF(C13:E13<MIN(C13:E13),C13:E13))