I am trying to put a formula in my spreadsheet that will put in a positive number in a column if the sum of 3 columns is a positive number. If I use sumif it gives me any positive numbers in the three columns i am totaling not the sum which may be a positive or negative number.QPRO uses a formula that is easy to produce. Will openoffice convert formulas from qpro or other spreadsheet programs? Any help greatly appreciated.
Ralph
