How to Add and Subtract in Excel

Addition and subtraction are the absolute foundation of working with numbers in Excel, and even after years of building complex formulas and dashboards, I still use these basic operations constantly — totaling expenses, calculating balances, or finding the difference between two figures. In this article, I’ll walk through every way I add and subtract in Excel, from simple formulas to functions built for larger datasets.

The Basics: Excel Operators

• Addition: the plus sign +
• Subtraction: the minus sign -

Every calculation formula begins with an equals sign =. So adding 10 and 5 looks like =10+5, and subtracting 5 from 10 looks like =10-5.

Step-by-Step: Adding Two Numbers

1. Click on an empty cell.
2. Type =, your first number, +, and your second number — for example, =15+27.
3. Press Enter.

The cell displays 42.

Step-by-Step: Adding Cell References

More often, I’m adding values that already live in other cells:

1. Click an empty cell for the result.
2. Type =, click the first cell (say A2), type +, then click the second cell (say B2).
3. Your formula reads =A2+B2.
4. Press Enter.

Step-by-Step: Subtracting Numbers or Cells

Subtraction works the same way with - instead of +:

• Raw numbers: =50-18 returns 32.
• Cell references: =A2-B2 subtracts the value in B2 from the value in A2.

Adding an Entire Column with SUM

Typing =A1+A2+A3+A4... for a long list of numbers is tedious and error-prone. Instead, I use the SUM function:

=SUM(A2:A20)

This adds up every value in that range instantly, no matter how many rows are involved. I can also add non-adjacent cells or ranges:

=SUM(A2:A10, C2:C10, E5)

Quick Totals Without Typing a Formula

If I just want to glance at a total without inserting a formula anywhere, I select the range of cells, and Excel automatically shows the Sum, Average, and Count in the status bar at the bottom-right of the window — no formula needed at all. Right-clicking that status bar also lets me add Min, Max, and other quick stats.

Using AutoSum

Excel has a built-in shortcut for quickly summing a column or row:

1. Click the empty cell right below (or beside) your data.
2. Go to the Home tab and click AutoSum (the Σ symbol), or press Alt + =.
3. Excel automatically guesses the range to sum and shows it as a formula.
4. Press Enter to confirm, or adjust the selected range first if needed.

AutoSum also has a dropdown with Average, Count, Max, and Min if I click the small arrow next to the Σ icon.

Subtracting a Column of Values from Another Column

If I have Revenue in column B and Costs in column C, and want Profit in column D for every row:

1. Click D2.
2. Type =B2-C2.
3. Press Enter.
4. Drag the fill handle (the small square at the bottom-right of the cell) down through the rest of the rows.

Excel automatically adjusts the row numbers for each row as you drag.

Adding or Subtracting a Fixed Number Across a Range

Sometimes I need to add or subtract one constant value across a whole range — like adding a fixed bonus amount to every employee’s salary. If that bonus is in cell E1, I lock it as an absolute reference using $ so it doesn’t shift when I copy the formula down:

=B2+$E$1

Now B3, B4, and so on will always reference the same fixed E1 cell, while B2 adjusts normally for each row.

Adding or Subtracting Without a Formula (Paste Special)

For a one-time bulk adjustment, I sometimes skip formulas entirely:

1. Type the number to add or subtract in any empty cell and copy it (Ctrl+C).
2. Select the range you want to adjust.
3. Right-click and choose Paste Special.
4. Under “Operation,” choose Add or Subtract.
5. Click OK.

This permanently changes the values in place — useful for quick bulk adjustments, but I’m careful with it since it overwrites the original numbers rather than calculating a new result I can trace.

Running Totals (Cumulative Sum)

When I need a running total that grows down a column — common in cash flow tracking — I use a mixed reference:

=SUM($A$2:A2)

Dragging this formula down keeps the starting point ($A$2) fixed while the ending point expands with each row, giving a proper cumulative total.

Practical Example

Say I’m tracking a simple monthly budget:

• Column A: Date
• Column B: Income
• Column C: Expense
• Column D: Net (Income − Expense)
• Column E: Running Balance

My formulas:

• D2: =B2-C2
• E2 (first row): =D2
• E3 onward: =E2+D3

This gives me a day-by-day net change and a running balance that updates automatically as I add new rows.

Common Mistakes I See

• Manually typing =A1+A2+A3... for long lists instead of using SUM — slow and error-prone if you miss a cell.
• Forgetting the equals sign, which makes Excel treat the entry as plain text.
• Not locking a fixed reference with $ when adding/subtracting the same constant across a range, causing the reference to shift incorrectly.
• Adding cells that are actually formatted as text, especially after importing data from another system — SUM will silently ignore text-formatted numbers, leading to totals that look wrong.
• Overwriting original data with Paste Special Add/Subtract without keeping a backup, since it’s a permanent change rather than a formula.

Troubleshooting Tips

• If SUM returns 0 or ignores some cells, check whether those numbers are actually stored as text (they’ll be left-aligned instead of right-aligned).
• If a formula shows as literal text instead of a calculated value, confirm the cell’s format is “General” or “Number,” not “Text.”
• If your running total looks wrong, double-check that your first-row formula and fixed reference ($) are set up correctly before dragging down.
• If AutoSum grabs the wrong range, just manually adjust the highlighted selection before pressing Enter — it doesn’t always guess perfectly, especially with blank cells nearby.

Real-World Use Cases

• Households tracking income, expenses, and running balances in a personal budget.
• Businesses calculating profit by subtracting costs from revenue across many products.
• Students totaling marks across multiple assignments or exams.
• Accountants calculating running balances in ledgers and cash flow statements.
• Project managers totaling hours worked or tasks completed across a team.

Best Practices I Follow

• Use SUM instead of manually chaining + for anything beyond 3–4 numbers.
• Lock fixed values with absolute references ($) whenever adding or subtracting one constant across a range.
• Use the status bar’s quick Sum/Average feature for fast checks without cluttering your sheet with extra formulas.
• Keep formulas instead of Paste Special whenever you might need to revisit or adjust the source numbers later — formulas stay transparent, while Paste Special permanently overwrites values.
• Format your numeric columns consistently as “Number” or “Currency” to avoid silent errors from text-formatted values being skipped in totals.

Addition and subtraction might be the simplest operations in Excel, but getting into good habits early — using SUM instead of chained + signs, locking references properly, and formatting numbers consistently — is what makes the rest of your spreadsheet work reliably as it grows more complex.