At the end, you will notice it subtracts the second output from the first outcome. Using this formula will first add the amounts in Column C and then in Column D. And then you have to subtract the sum of another range from 1st range. Suppose you need to add a cell range from C5:C10 and D5:D10. The parenthesis always indicates the number values are negative, therefore remember that when you are trying to add such amounts in a single SUM function, it means you are adding positive values and subtracting the negative values simultaneously.Īdd and Subtract Two Columns in One Formula with the SUM Function You can see the March savings are not opened in the first bracket.In cell E11, put the following formula:.Here you will see the use of the SUM function to find the net saving figure. That’s it! Add and Subtract in One Column with the SUM Functionĭo you know subtracting a value from another value is the same thing as adding a positive and a negative value?
0 kommentar(er)
