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.

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

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
---