What should happen if there aren't at least 5 scores?
Does not matter.

You must have magical powers. You're so good you can read the OP's mind?

=AVERAGE(SMALL(A1:A99,ROW(INDIRECT("1:"&MIN(COUNT A(A1:A99),4)))))

That won't do what the OP asked for.

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Hello,

...
What should happen if there aren't at least 5 scores?
...

Does not matter. Array-enter
=AVERAGE(SMALL(A1:A99,ROW(INDIRECT("1:"&MIN(COUNTA (A1:A99),4)))))

Regards,
Bernd