I have rows of data and would like to sum all but the lowest 2 or 3 or 4 entries. What is the easiest way to do this? Does it involve a macro.
I prefer open office spreadsheet, but could also use excel if the answer for excel is much simpler.
I have rows of data and would like to sum all but the lowest 2 or 3 or 4 entries. What is the easiest way to do this? Does it involve a macro. I prefer open office spreadsheet, but could also use excel if the answer for excel is much simpler. 


Try using the SMALL function in excel it will definitely get you the second, third or the fourth lowest value in that row Resource taken from here Instructions on using SMALL function (taken from here)



Can you clarify your question more? Do you mean you want to add all values of a row but last 3 or 4? Generally you select the elements and add like sum(A1:X1), exluding the elements in Y1 and Z1 for row 1. 

