Excel Sum Minus: How to Add and Subtract Numbers in Excel

How-to basics · Updated November 18, 2026

To subtract a value from a total in Excel, combine SUM with the minus sign: with numbers in B2:B6 and the amount to subtract in C2, enter =SUM(B2:B6)-C2. If B2:B6 contains 10, 20, and 5, and C2 contains 8, the result is 27.

What “sum minus” means in Excel

“Sum minus” is not a special Excel function. It usually means adding a group of numbers and then subtracting one or more amounts, or subtracting one total from another. Excel uses the standard minus operator (-) for subtraction, while SUM adds numbers in cells or ranges. You can use them together in one formula.

This is useful for everyday calculations such as working out a balance after expenses, remaining inventory after orders, net sales after returns, or the difference between two totals. The formula updates when its referenced cell values change, so you do not need to redo the arithmetic manually.

Excel calculates expressions according to mathematical order of operations. Parentheses are evaluated first, followed by multiplication and division, then addition and subtraction. When an expression contains only addition and subtraction, Excel evaluates those operations from left to right. Parentheses make your intention clearer, especially when you are subtracting a combined amount.

Subtract one amount from a SUM total

The simplest pattern is to sum a range and subtract a single cell. With sales values in B2:B6 and a discount in C2, use =SUM(B2:B6)-C2. If the sales values are 100, 40, and 15, and the discount is 20, the result is 135: the range totals 155, and 155 minus 20 equals 135.

To enter the formula in Microsoft Excel for Microsoft 365 on Windows:

  1. Select the cell where you want the answer to appear.
  2. Type an equals sign, then the formula, including the cell references and range.
  3. Press Enter. The result appears in the selected cell.
  4. Change any input value to confirm that the result recalculates automatically.

You can also select the cells with the mouse while building the formula. Type the beginning of the formula, select the range to include it, type the minus sign, and select the cell to subtract. A formula must begin with an equals sign for Excel to calculate it; without one, Excel may treat the entry as text.

Subtract one range total from another

When both sides contain several values, sum each range separately and subtract one sum from the other. With income in B2:B6 and expenses in C2:C6, use =SUM(B2:B6)-SUM(C2:C6). If the income entries are 100, 40, and 15 and the expense entries are 20, 10, and 5, the result is 120: income totals 155, expenses total 35, and 155 minus 35 equals 120.

This layout is often easier to check than a long expression listing every cell individually. It also makes the purpose of each range visible: one range represents money coming in, and the other represents money going out. For a worksheet you will reuse, add clear column headings such as Income and Expenses, and keep the input data in consistent rows.

Check that the ranges cover the same intended records. If a new transaction is entered below the last row included in a formula, that transaction will not affect the result. One practical fix is to convert the data range into an Excel table using Insert > Table; formulas and ranges can then be easier to maintain as rows are added.

Subtract several individual values

You can subtract a series of cells directly. With a starting amount in B2, and deductions in C2 and D2, enter =B2-C2-D2. If B2 is 100, C2 is 20, and D2 is 5, the result is 75. This works well for a short calculation where the individual deductions are easy to identify.

For a grouped deduction, parentheses help show that the deductions should be added together before being taken away. With the same layout—starting amount in B2 and deductions in C2 and D2—use =B2-(C2+D2). With values of 100, 20, and 5, it also returns 75. The two formulas are mathematically equivalent in this example, but parentheses can make a complicated calculation much easier for another person to review.

For many deductions, it is generally clearer to place them in a range and subtract its sum rather than extending a formula with a long chain of minus signs. A range-based formula is easier to expand and less likely to omit a cell when the list grows.

When negative values are already in the data

Sometimes expenses or adjustments are recorded as negative numbers. In that setup, adding the entire range may already produce a net total; subtracting those negative entries again would reverse their effect. With amounts in B2:B6, where the entries are 50, -12, and 30, use =SUM(B2:B6) to get 68. The calculation is 50 minus 12 plus 30.

Choose one consistent sign convention. You can record all outflows as positive amounts and subtract their total from income, or record outflows as negative amounts and add all entries together. Mixing the two conventions can double-count an expense or turn a deduction into an addition.

  • Positive expenses: add income in one range, add expenses in another, and subtract the expense total.
  • Negative expenses: enter outflows as negative values and sum inflows and outflows together.

Also consider how the result is formatted. A negative result is not automatically an error: it may mean that expenses exceed income or that more items were removed than were available. Number formatting changes how a value looks, not the arithmetic Excel performs.

Subtract totals by category

If a single list contains different types of transactions, you can total specific categories before subtracting. With category names in A2:A10 and amounts in B2:B10, use =SUMIF(A2:A10,"Sales",B2:B10)-SUMIF(A2:A10,"Returns",B2:B10). If Sales amounts total 150 and Returns amounts total 30, the result is 120.

SUMIF adds values that match one criterion. In this example, the first part adds amounts whose category is Sales, and the second part adds amounts whose category is Returns. The formula then subtracts the returns total from the sales total. The text criteria need quotation marks inside the formula; the HTML display above represents those quotes as character entities.

For a workbook that will be used by others, you may prefer to put the category names in cells and refer to those cells as criteria. That makes it possible to change the categories without editing the formula itself. Ensure the category text is consistent in the data: extra spaces or spelling differences can prevent a row from matching the criterion.

Common mistakes and how to check them

A formula can produce an unexpected result even when the minus sign is correct. Check these common causes before changing the calculation:

  • The wrong range is selected. Confirm the first and last cells include all intended values and exclude headings or unrelated records.
  • A value is outside the range. If the formula stops at row 10 but a transaction is in row 11, it will not be included.
  • A number is stored as text. Some imported values look like numbers but are text, so they may not behave as expected in arithmetic. Check the cell alignment, warning indicators, and source data, then convert the entries to numbers if appropriate.
  • A cell contains text where Excel expects a number. A direct subtraction involving text can return #VALUE!. Correct the input rather than hiding the error if the value should be numeric.
  • Expenses use inconsistent signs. Review whether outflows should be positive deductions or negative entries, and apply the same method throughout the calculation.
  • Parentheses are missing or misplaced. Add parentheses when you mean to subtract a combined group, then compare the formula with the calculation you intended.

To audit a formula, select its result cell and inspect the formula bar. You can also select a referenced cell to verify its value and use the Formulas tab’s formula-auditing tools to trace precedents when you need to see which cells feed into a calculation. For a small example, calculate each subtotal separately in spare cells and compare their difference with the main formula.

SUM with minus versus other approaches

For a small, fixed calculation, direct subtraction between cells is compact. For example, subtracting two totals works naturally with a minus sign between two SUM expressions. If you are calculating a net amount from a categorized transaction list, SUMIF can keep the category rule inside the formula. If your data already uses negative values for outflows, a single SUM may be the simplest choice.

Pick the approach that matches how the source data is organized rather than trying to make every calculation look alike. A formula that is short but relies on unclear signs can be harder to maintain than one that uses separate, well-labeled totals. For shared workbooks, add headings and, where useful, a brief note explaining whether expenses are entered as positive or negative amounts.

These arithmetic formulas work in Excel for Microsoft 365 on Windows, Mac, and Excel for the web. The interface for entering formulas differs slightly by platform, but the minus operator and SUM syntax do not. Excel uses commas between function arguments in the examples here; the regional settings on some computers may require semicolons instead.

Frequently Asked Questions

How do I subtract a number from a SUM formula?
Put a minus sign after the closing parenthesis of SUM, then reference the cell to subtract. Make sure the range and the individual cell represent the values you intend to use.

Can I subtract two SUM formulas?
Yes. Put one SUM expression on each side of the minus sign. This is useful when comparing a total for income or sales with a separate total for costs or returns.

Why does my subtraction formula show a negative number?
A negative result means the amount being subtracted is larger than the starting total. Check the inputs and signs, but if the values are correct, the negative result may accurately show a shortfall.

Should I enter expenses as positive or negative numbers?
Either convention can work. Enter positive expenses when you plan to subtract an expense total; enter negative expenses when you plan to add all transactions together. Avoid mixing the conventions in one calculation.

Does SUM ignore blank cells?
Yes. A blank cell in a range contributes no amount to the sum. However, a cell containing text is not the same as a blank, and text used directly in arithmetic can cause an error.

Can I use SUM minus in Excel for Mac or the web?
Yes. The same formulas work in Excel for Mac and Excel for the web. Ribbon locations and keyboard interactions can vary by platform, but you can enter the formula in a cell and press Enter to calculate it.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.