Aha now I understand. Allmost. But when I use:
=ADD.IF(C6:I6;"LARGE(C5:G5;2)") it will not work.

Maybe I need to convert the LARGE(C5:G5;2) to a string. ?

It is working when I use
=ADD.IF(C6:I6;"2")

Tudor

"JulieD" skrev:

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