Quick question

E

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.
 
P

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
 
Top