Quick question

[Eddie Grogan]

Hi,

I would appreciate if someone could help me with the following
problem. I have 8 cells containing numeric values. I need to calculate
average value for the sum of the largest six cells (i.e. discarding to
two lowest values).

For example:
C1 = 30
C2 = 20
C3 = 30
C4 = 15
C5 = 30
C6 = 10
C7 = 40
C5 = 30

Thus discarding C6 & C4, and calculating the average value of the
remaining cells- 180/6 = 30.

Thanks
Eddie.

 

[Paul B]

Eddie, here is one way, =AVERAGE(LARGE(C1:C8,ROW(INDIRECT("1:6")))) this
is an array formula.
enter with ctrl + shift + enter.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2003

 

[Jim May]

Or =AVERAGE(LARGE($C$1:$C$8,{1,2,3,4,5,6})) 'without Ctl+Shft+Enter