| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear the lowest 10 values from a list of 30 values | New Users to Excel | |||
| Lowest two values | Excel Worksheet Functions | |||
| Summing numbers dropping lowest and highest | Excel Worksheet Functions | |||
| Dropping the lowest score from a gradebook | Excel Worksheet Functions | |||
| Finding the average by dropping the lowest | Excel Worksheet Functions | |||
Linear Mode
