Thread: Average of ...
View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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