Autosum Selected Cells: How to Use It

Updated 15 November 2026 · Standard formula, shown below

AutoSum in Excel and Google Sheets adds up the numbers in a selected range with one click, saving you from typing a SUM formula manually. You select the cells you want to total, click the AutoSum button (Σ), and the program inserts the formula and shows the result. This article explains exactly how it works, how to use it for rows, columns, and non-adjacent cells, and how to avoid the most common mistakes.

What AutoSum Actually Does

AutoSum is a shortcut that inserts the SUM function into a cell. It does not calculate the total itself; it writes a formula that does. When you click the AutoSum button (usually labeled Σ in the toolbar), Excel or Sheets looks at the selected cell and guesses which range you want to sum—typically the contiguous numbers directly above or to the left. It then places =SUM(A1:A10) (or similar) into the active cell, and you press Enter to confirm.

Because it inserts a formula, the total updates automatically if you change any number in the range. That is the key difference between AutoSum and simply typing a number.

How to Use AutoSum on Selected Cells

The most common way to use AutoSum is to select the cells you want to add, then click the button. But there are a few variations depending on what you need.

Summing a Column or Row

Click the cell where you want the total to appear (usually just below a column of numbers, or to the right of a row).
Press Alt + = (Windows) or Command + Shift + T (Mac) in Excel, or use the Σ button in the toolbar.
Excel suggests a range. If it is correct, press Enter. If not, drag to select the correct range before pressing Enter.

If you want to sum a specific set of cells that are not contiguous, hold Ctrl (Windows) or Command (Mac) while clicking each cell, then press Alt+=. The formula will use commas to separate the references, like =SUM(A1,A3,A5).

Selecting Cells Before Clicking AutoSum

You can also select the range first and then click AutoSum. This works in both Excel and Google Sheets, but the behavior differs slightly:

Excel: If you select a range of numbers and then click AutoSum, Excel places the total in the first empty cell below (or to the right of) the selection. It does not overwrite any data.
Google Sheets: If you select a range and click Σ, Sheets inserts the sum in the first blank cell below the range. If there is no blank cell, it may overwrite the cell immediately below unless you choose a destination.

In both cases, the formula is inserted, not a static value.

Common Problems and Fixes

AutoSum Ignores Some Cells

If you have blank cells or text within the range, AutoSum may not include everything you expect. For example, if you select A1:A10 but A5 is empty, the formula =SUM(A1:A10) still includes it (as zero), so it works. However, if you have text like “N/A” in a cell, SUM ignores it, which is usually fine. But if you have numbers stored as text, SUM may skip them, giving a lower total than expected. To fix, convert text-formatted numbers to real numbers (use the “Convert to Number” warning in Excel).

AutoSum Picks the Wrong Range

Sometimes Excel guesses too large or too small a range. If you have numbers both above and below the active cell, AutoSum might only select one side. Always check the dashed border (the “marquee”) before pressing Enter. If it is wrong, drag to highlight the correct cells, or type the range manually.

AutoSum Returns 0

If the result is 0, the selected cells likely contain text, or the numbers are formatted as text. Use the ISNUMBER function to check, or re-enter the numbers. Also ensure that the cells are not in a different worksheet that is hidden.

AutoSum vs. Manual SUM Formula

AutoSum is just a faster way to write =SUM(). There is no difference in the result. However, manual entry gives you more control:

You can type =SUM(A1:A10) directly, which is useful when you want to sum across multiple sheets (e.g., =SUM(Sheet1:Sheet3!A1)).
You can use SUMIF or SUMIFS for conditional sums, which AutoSum does not offer.
You can combine SUM with other functions like =SUM(A1:A10)/COUNT(A1:A10) for an average.

AutoSum is best for quick, straightforward totals. For anything more complex, write the formula manually.

AutoSum in Google Sheets vs. Excel

Both applications have AutoSum, but there are small differences:

Keyboard shortcut: Excel uses Alt + =. Google Sheets uses the same shortcut (Alt + =) on Windows, but on Mac it is Command + Shift + T.
Button location: In Excel, the Σ button is on the Home tab, in the Editing group. In Google Sheets, it is in the toolbar, near the function icon (fx).
Range selection: Google Sheets is sometimes more aggressive in guessing the range, and it may include empty cells in the middle of a column. Always verify the highlighted range.

Both tools allow you to select cells first and then click the button, but the destination cell may differ. In Excel, if you select a range and click AutoSum, the total goes to the cell below the selection. In Sheets, it also goes below, but if there is already a value there, it may overwrite it—so be careful.

Frequently Asked Questions

Can I use AutoSum on non-adjacent cells?

Yes. Hold Ctrl (or Command on Mac) and click each cell you want to include, then press Alt+=. The formula will use commas, like =SUM(A1,C1,E1). This works in both Excel and Google Sheets.

Why does AutoSum sometimes give a wrong total?

The most common reason is that some cells contain text or are formatted as text. SUM ignores text, so those numbers are not counted. Another reason is that the range selection is incorrect—AutoSum may have missed a cell or included an extra one. Always check the range before pressing Enter.

How do I sum a column that has blank cells?

AutoSum will still work because SUM treats blanks as zero. However, if you have blank cells and want to sum only the visible cells (for example, after filtering), use the SUBTOTAL function instead: =SUBTOTAL(9, A1:A100). AutoSum does not automatically use SUBTOTAL.

Does AutoSum work on filtered data?

No. AutoSum uses the SUM function, which ignores filters and sums all cells in the range, including hidden ones. To sum only visible filtered cells, use SUBTOTAL(9, range) or AGGREGATE(9, range).

Can I change the range after AutoSum is inserted?

Yes. Click the cell with the formula, then drag the blue outline (in Excel) or the blue corner (in Sheets) to include more or fewer cells. The formula updates automatically.

Is there a way to AutoSum multiple rows at once?

Yes. Select the range of numbers plus the empty cells where you want the totals to appear (for example, A1:C10 and A11:C11), then press Alt+=. Excel will insert SUM formulas for each column in the selected area.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.