Read More: Subtraction for Whole Column in Excel (with 5 Examples) 2. So, you’ve successfully subtracted Total Expense from Total Revenue. After that, drag the Fill Handle icon from cell E5 to E12. Excel is flexible enough to allow just about any calculation you might need. C5-D5 Here, C5 has an amount of Total Revenue and D5 has an amount of Total Expense. In this example, each month’s sales were greater than the previous month except June, when the sales dropped back to April levels.Īs you continue working in Excel, you’ll learn additional uses of subtraction, such as subtracting dates or calculating change percentages. You can copy this formula to cells D11-H11 to complete your change calculations.

Type “=” to tell Excel that you are beginning a formula.

Subtract One Number from Each Value within a Cell Range If you need to subtract a. B5 will now return the value 200 as shown below. But, in this case, you need to supply cells instead of the numbers. Input the formula ‘ B3-B4 ‘ and press the Return key. Each formula in Row 11 is the result of subtraction using the “-” (hyphen) as a minus sign. In Excel, you can also subtract one cell from another using the minus formula. Row 11 shows the change from the prior month.

Row 9 displays the total of sales for all cities.Īre the sales increasing each month? If so, by how much? In this example, columns C through H show the sales for each month. Unfortunately, Excel doesn’t have a SUBTRACT formula.

You need to subtract the prior month’s sales from the current month’s sales. Your boss asks you to add a row that shows the change from the prior month. You have created a report that shows your company’s sales by month.

Formula for subtraction in excel