ExcelBanter - Dropping lowest 2 values

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Dropping lowest 2 values (https://www.excelbanter.com/excel-programming/278536-re-dropping-lowest-2-values.html)

merjet

Dropping lowest 2 values

Suppose the 24 columns are A-X and your current
sums are in Y, e.g.with formula ==SUM(A1:X1).
Then change that formula to, or put in another cell:
=SUM(A1:X1)-SMALL(A1:X1,1)-SMALL(A1:X1,2)

HTH,
Merjet

J.E. McGimpsey

Dropping lowest 2 values

IF you prefer, you could combine the last two terms:

=SUM(A1:M1)-SUM(SMALL(A1:M1,{1,2}))

In article <oFIeb.656256$uu5.106763@sccrnsc04,
"merjet" wrote:

Suppose the 24 columns are A-X and your current
sums are in Y, e.g.with formula ==SUM(A1:X1).
Then change that formula to, or put in another cell:
=SUM(A1:X1)-SMALL(A1:X1,1)-SMALL(A1:X1,2)

All times are GMT +1. The time now is 09:17 AM.