Forum Discussion
looking for a short formula
I have several columns that need add then subtract then add then subtract. For example, Is there a way to short the formula? Thanks, M.
Mangoorani Not sure if your example is realistic, but if it is you could perhaps consider entering all the numbers that should be subtracted as negative numbers. Then the formula in your example could become =$B4 - SUM($D4:$AB4)
- Every other column is add then subtract from B4-AB4, so the sum formula won't work.
Mangoorani Perhaps you missed a few words in my earlier reply, where I suggested that you could perhaps enter the numbers that need to be subtracted as negative numbers. Then you can use the SUM function as demonstrated in the picture below.
