subtraction excel formula multiple cells

The cell range A3:B7 shows the daily calorie intake breakdown, and cell B7 shows the total daily calorie intake as the sum of the calories contributed by the three nutrients, 2200. The below image shows the calorie data of a person.Ĭell B contains the required daily calories, 2500. The following Excel Subtraction formula example shows the different ways of subtracting Excel cells. The resulting savings in cell D7 is negative as the expenses are more than the specified June month income.Ĭheck out the below Excel Subtraction formula examples to use the formula effectively. It subtracts the second value from the first to return the difference of -$600. The Subtraction formula takes the cell references to the June month’s income and expenses values, $1,500 and $2,100, as input. Let us consider the cell D7 expression to see how the formula works. Using the fill handle, enter the formula in cell range D3:D7.=B2-C2 Entering the input values directly in the Subtraction formula will give the same result. Select the target cell D2, enter the Subtraction formula, and press Enter.

Excel will close the parenthesis for you automatically and perform the calculation.The steps to use Subtraction formula in excel is as follows – While holding the mouse button, drag the mouse from A1 all the way to A10. That is an equal sign, the word SUM, and an open parenthesis.ģ.

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. 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. How to subtract a range of numbers in Excel

Subtraction excel formula multiple cells