Hi Tudor
=SUM(LARGE(B2:B7,{1,2,3,4}))
where your range is B2:B7 is the range containing your 6 cells.
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tudor" wrote in message
...
Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.
tnx