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.
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.