summing a row, remove lowest values from the total

[randy chapman]

Is there a way to remove the lowest 5 cell values from the sum of a row of 20
cells.

 

[Gary''s Student]

=SUM(A1:T1)-SUM(SMALL(A1:T1,{1,2,3,4,5}))

 

[Max]

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

---