How To Add In Microsoft Excel
To add in Microsoft Excel, select an empty cell, type =SUM(A1:A5), and press Enter to total the numbers in cells A1 to A5. For a few individual values, use a formula such as =A1+B1. AutoSum creates a SUM formula for you, while SUMIF and SUMIFS.
Which licences fit your PC setup?
Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.
-

Office 2021 Pro Plus key
$57.00 AUD
-

Office 2019 Pro Plus key
$45.00 AUD
-

Microsoft 365 Pro Plus, 5 devices
$15.00 AUD
$29.00
Add two or more numbers with a formula
Every Excel formula starts with an equals sign. Without it, entering 10+20 does not tell Excel to calculate a total.
- Select an empty cell where you want the answer.
- Type =10+20+5.
- Press Enter. The cell displays 35.
For numbers already in your worksheet, use cell references instead of typing the values again. For example, =A1+B1 adds the contents of those two cells. You can type the references or click each cell as you build the formula, placing a plus sign between them.
Cell references keep your calculation connected to your data. When you change a referenced value, Excel updates the result automatically under its normal automatic calculation setting.
Use SUM to total a column or row
SUM is easier to manage than a long chain of plus signs. A colon describes a continuous range: A1:A5 includes A1, A2, A3, A4 and A5.
- Enter your numbers in cells A1 to A5.
- Select A6, below the numbers.
- Type =SUM(A1:A5).
- Press Enter to display the total.
To total a row, use a horizontal range such as =SUM(B2:F2). Place that formula in G2 or another cell outside the range. Including the total cell in its own formula creates a circular reference.
Add separate cells and ranges
You can combine several references in one SUM formula. These examples show the difference between a range and a list of individual cells:
- =SUM(A1:A5) adds every cell from A1 through A5.
- =SUM(A1,A3,A5) adds only those three cells.
- =SUM(A1:A5,C1:C5) adds two separate ranges.
The examples here use commas between function arguments. If your regional settings require semicolons, replace those separating commas with semicolons.
Use AutoSum for adjacent numbers
AutoSum inserts a SUM formula and suggests a nearby range. Microsoft's AutoSum instructions describe using it for a column or row.
- Select the empty cell directly below a column of numbers, or immediately to the right of a row.
- On the Home tab, select AutoSum.
- Check the highlighted range. If it misses any values or includes unwanted cells, select the correct range before continuing.
- Press Enter to accept the formula.
Blank cells can affect the range Excel suggests, so inspect both ends of the selection. Also check that you have not included an existing subtotal along with the individual values it already totals.
Check a total without entering a formula
Select a group of numeric cells and look for Sum on Excel's status bar at the bottom of the window. This gives you a quick check without placing a result in the worksheet.
If Sum is missing in desktop Excel, right-click the status bar and enable it. Use a worksheet formula when you need to save the total, refer to it in another calculation, or include it in a printed report.
Add values that meet a condition
Use SUMIF for one condition
Suppose A2:A10 contains department labels and B2:B10 contains amounts. To add only the amounts labelled Sales, enter:
=SUMIF(A2:A10,"Sales",B2:B10)
The first range contains the labels Excel checks. The second argument is the condition, and the final range contains the numbers to add. Keep the label and amount ranges aligned so each amount matches the correct row.
You can also test the numbers themselves. For example, =SUMIF(B2:B10,">100") adds values greater than 100 in that range. Text criteria and comparisons such as ">100" need quotation marks.
Use SUMIFS for several conditions
If C2:C10 contains regions, this formula totals amounts where the department is Sales and the region is West:
=SUMIFS(B2:B10,A2:A10,"Sales",C2:C10,"West")
SUMIFS puts the sum range first, followed by pairs of criteria ranges and conditions. All the conditions must match for a row to contribute to this total. Microsoft's guide to summing values based on multiple conditions explains this argument order.
Add numbers from different worksheets
Include a sheet name followed by an exclamation mark to refer to another worksheet. For example, =January!B2+February!B2 adds B2 from each named sheet.
To add ranges from both sheets, use =SUM(January!B2:B10,February!B2:B10). If a sheet name contains spaces, enclose it in single quotation marks, as in =SUM('January Sales'!B2:B10).
Before combining sheets, check that their ranges represent the same kind of data. Adding a quantity column to a currency column produces a number, but not a useful total.
Multiply matching values, then add the results
For an order total, you may need to multiply each quantity by its unit price before adding the line amounts. If quantities are in B2:B10 and prices are in C2:C10, use:
=SUMPRODUCT(B2:B10,C2:C10)
This multiplies each pair of values on the same row and adds the products. Both ranges must have matching dimensions. For a beginner-friendly alternative, calculate each line amount in a separate column, then use SUM on that column.
Fix unexpected totals
- Check numbers stored as text. SUM ignores text in referenced cells, so imported numeric-looking entries can be missed. Convert them to numbers before totalling.
- Check the formula's range after adding new data. Values entered outside that range will not be included.
- Investigate errors such as #VALUE! in the source cells. Correct the underlying problem before relying on the total.
- Use the underlying condition to total highlighted entries. Ordinary SUM does not select values by fill colour or conditional formatting.
For other spreadsheet tasks, browse the Microsoft Office guides. If you are setting up Office before working in Excel, the separate guides cover activating Microsoft Office using CMD and finding a Microsoft Office product key using Command Prompt.
Start with a short column in your own worksheet, add a SUM formula below it, and change one source value to check that the total updates.
Other editions for separate workloads
Other editions for separate workloads; prices in AUD, confirm the total on the listing.
-

Windows 11 Pro key
$14.99 AUD
$29.00 -

Office 2024 Pro Plus key
$20.00 AUD
$39.00 -

Windows 11 Home key
$18.88 AUD
$37.00
How to check this worked
- Open Settings, System, Activation and confirm the edition shown.
- Enter the key and run activation; expect a green tick within a minute.
- Reboot and re-check activation survives the restart.
FAQ
What else should you know before buying?
- What do I need before starting?
- Read the requirements and confirm the edition first; the steps assume the machine is compatible.
- How do I know the licence is genuine?
- Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
- Is this a subscription?
- Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
- What if the key fails?
- Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.
Check who prepared and reviewed this guide
- Written by
- MS.Codes editorial
- Reviewed by
- Support team
Last verified: (source review; see test status above).