Is there a way to remove the lowest 5 cell values from the sum of a row of 20 cells.
R randy chapman Feb 20, 2008 #1 Is there a way to remove the lowest 5 cell values from the sum of a row of 20 cells.
M Max Feb 20, 2008 #3 randy chapman said: Is there a way to remove the lowest 5 cell values from the sum of a row of 20 cells Click to expand... 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)))
randy chapman said: Is there a way to remove the lowest 5 cell values from the sum of a row of 20 cells Click to expand... 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)))
