This operator will subtract numbers from each other, providing the difference between. Excel will close the parenthesis for you automatically and perform the calculation. To subtract multiple cells using a formula in Excel, use the - operator. SUM (C5-D5) Here, cell C5 has the Total Revenue amount and cell D5 has the Total Expense amount. Now follow the steps below: First, insert the following formula in cell E5.

We can also use the SUM functionsubtractTotal Expense from the Total Revenue. While holding the mouse button, drag the mouse from A1 all the way to A10. Subtract from a Total in Excel Using SUM Function. That is an equal sign, the word SUM, and an open parenthesis.ģ. First highlight the cells for the column you want to change, then use the SUM formula to add them up. Click the cell where you want the final result to appear (such as A11). Remember that any numbers you want to subtract should have a minus sign ( -).Ģ. Enter the numbers you want to use in each cell from A1 through A10. In fact, this function can combine addition and subtraction into a single operation - you simply need to put a minus sign in the cell of every number you want to subtract (this means the number will look like a negative number).ġ. Using the SUM function, we can calculate the result easily. Suppose you have a set of numbers stored in cells A1 through A10, and you want to subtract them. Displays the contents of cell A1 plus 10.

Here are a few examples of LibreOffice Calc formulas: A1+10. The result of the formula (1+2)3 produces a different result than 1+23. You can use the previous technique to subtract cells, but if you have several cells you want to subtract, there is an easier method - you can subtract a range of cells all at once. Instead of writing SUM (A1:B1) you can write A1+B1. How to subtract a range of numbers in Excel

Excel spreadsheet subtraction formula