PDA

View Full Version : looking for Office MS similar sum feature



ub9876
November 5th, 2007, 01:23 AM
looking for a tool that adds all the numbers that are highlighted in a row. Open Office doesnt do this well. for ubu. any ideas??

Zugzwang
November 5th, 2007, 07:06 PM
Don't Know of any. Maybe you can create an extra row in which you add the information if the cell above is selected or not and use the SUMIF function?

In OpenOffice, for example, you type the number into the cells A1...E1 and the information whether the cells are selected or not into A2...E2. Then you can use the formula "=SUMIF(A2:E2;">" & 0;A1:E1)" to get the conditional sum as requested.