Hi Bob

thanks ... !

--
Cheers
JulieD

"Bob Phillips" wrote in message
...
Hi Julie,

I think you mean

=AVERAGE(LARGE(B2:B7,{1,2,3,4}))

Bob


"JulieD" wrote in message
...
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