Easy Tech TutsHow to Add Numbers in Excel Easily 2026
By Impran M N
Adding numbers by hand or on a calculator wastes time and invites mistakes, especially once your spreadsheet grows. Excel gives you several built-in ways to total values so your sums update the instant the underlying data changes. This guide covers the main approaches, from a basic plus-sign formula to the AutoSum shortcut.
01Use a basic plus-sign formula for a few cells
For adding a handful of specific cells, type an equals sign followed by the cell references separated by plus signs, such as =A1+A2+A3, and press Enter.
02Use the SUM function for a range
For longer lists, the SUM function lets you total an entire range at once by typing =SUM( followed by the range of cells, which avoids typing out every reference individually.
03Try the AutoSum shortcut
Excel's AutoSum button automatically detects the adjacent numbers and inserts a SUM formula for you, making it the fastest option when you just need a quick column or row total.
04Extend a formula down a column or across a row
Once you have one working total formula, drag the fill handle to copy it down a column or across a row so every row or column gets its own total without retyping the formula.
05Verify totals with the status bar
Select a range of numbers and check the sum shown in Excel's status bar at the bottom of the screen as a quick way to double-check a total without writing a formula at all.
Frequently asked questions
What's the fastest way to add a column of numbers in Excel?
Select the cell below the column and use the AutoSum shortcut, which automatically detects the numbers above and inserts a SUM formula.
Does the total update automatically if I change a number?
Yes, formulas like SUM recalculate instantly whenever any of the referenced cells change.
Can I add numbers from non-adjacent cells?
Yes, you can list individual cells separated by commas inside a SUM function, or use plus signs between individual cell references.
Why is my SUM formula showing an error?
This usually happens when the range includes text or improperly formatted numbers, so check that every cell in the range actually contains a numeric value.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
