G3+
AVERAGE(B3:F3)+SMALL(B3:F3,1)/10000+SMALL(B3:F3,2)/10000000+SMALL(B3:F3,3)/10000000000+SMALL(B3:F3,4)/10000000000000

You can ot have a 5th values being of use as one of the average or the
previous 4 would have had an effect

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558468