Formula

[Naas]

I want to sum 9 cells in column, throwing out the 2
lowest values,adding 10 to the result.

Please help.

Thanks

Naas

 

[Frank Kabel]

Hi
see your response in Excel.misc

P.S.: please don't multipost

 

[JE McGimpsey]

One way (array-entered: CTRL-SHIFT_ENTER or CMD-RETURN):


=SUM(LARGE(A1:A9,ROW(INDIRECT("1:7"))),10)

 

[JE McGimpsey]

Or, without array-entering:

=SUM(LARGE(A1:A9,{1,2,3,4,5,6,7}),10)