| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a row, remove lowest values from the total
Is there a way to remove the lowest 5 cell values from the sum of a row of 20
cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing a row, remove lowest values from the total
=SUM(A1:T1)-SUM(SMALL(A1:T1,{1,2,3,4,5}))
-- Gary''s Student - gsnu200769 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summing a row, remove lowest values from the total
"randy chapman" wrote:
Is there a way to remove the lowest 5 cell values from the sum of a row of 20 cells Assume the 20 source cells are A1:A20 Try this in B1, press CTRL+SHIFT+ENTER to array-enter the formula (instead of pressing ENTER): =SUM(A1:A20)-SUM(SMALL(A1:A20,ROW(1:5))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I calculate the total of the lowest 10 numbers in an array | Excel Discussion (Misc queries) | |||
| Summing related cell values and returning total to summary | Excel Discussion (Misc queries) | |||
| how do i remove 5 lowest scores? | Excel Discussion (Misc queries) | |||
| Need help summing the total of two columns with their products | Excel Discussion (Misc queries) | |||
| Lowest value in top 80% of Total? | Excel Discussion (Misc queries) | |||
Linear Mode
