One way:

=IF(COUNT(A1:A10)=4,AVERAGE(LARGE(A1:A10,{1,2,3,4 })),"")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"ferg" wrote in message
...

Thanx Rafeek & Leo both formulas work
Now can i put IF in formula so i dont get #num with less than 4 nums
In other words i dont want a calculation ( blank cell) unless there is
4 nums plus
Thanx;)


--
ferg
------------------------------------------------------------------------
ferg's Profile:
http://www.excelforum.com/member.php...o&userid=36519
View this thread: http://www.excelforum.com/showthread...hreadid=562810