formula

[Naas]

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

Please help.

Naas

 

[Frank Kabel]

Hi
if your range is A1:A9 try
=SUM(A1:A9)-MIN(A1:A9)-SMALL(A1:A9,2)+10

 

[Bob Phillips]

An alternative

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

and here's a more dynamic version that doesn't depend upon the number of
entries

=SUM(LARGE(A:A,ROW(OFFSET(A1,,,COUNTA(A:A)-2))))+10

but it's an array formual

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

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

Please help.

Naas


.
SUM(A1:A9)-(SMALL(A1:A9,1)+SMALL(A1:A9,2))+10