N
Naas
I want to sum 9 cells in column, throwing out the lowest
2 values , adding 10 to the result.
Please help.
Naas
2 values , adding 10 to the result.
Please help.
Naas
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
if your range is A1:A9 try
=SUM(A1:A9)-MIN(A1:A9)-SMALL(A1:A9,2)+10
if your range is A1:A9 try
=SUM(A1:A9)-MIN(A1:A9)-SMALL(A1:A9,2)+10
B
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)
=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)
B
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)
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)
G
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