Google Sheets Auto Sum: How to Total a Column Automatically

To auto sum a column in Google Sheets, select the cell where you want the total, choose the Σ Functions button and select SUM, then check the suggested range and press Enter. For a total that keeps including new entries, use a SUM formula in a cell outside the data column. You need a Google Sheets spreadsheet with numeric values and a clear idea of which rows should count.

What You’ll Need

A spreadsheet open in Google Sheets in a web browser.
A column of values to add. A text heading is fine, but the cells you want included should contain numbers or values Sheets recognizes as numbers.
An empty cell for the total. Decide whether it should sit beneath a fixed list or somewhere separate so it cannot be included in its own calculation.

Step-by-Step

Check the column and choose the result cell. Find the first and last rows of the values you want to add. For example, if A1 is a heading and values run from A2 through A20, decide whether you want a fixed total in A21 or a total elsewhere, such as B1. A fixed total below the list is convenient, but it needs a range that stops above the total cell. A total outside the list is better if new rows may be added frequently.
Use the toolbar’s SUM option for a quick total. Click the empty cell where the result should appear, such as A21 when the values are in A2:A20. Click the Σ Functions button in the toolbar and choose SUM. Google Sheets inserts a formula and usually suggests the adjacent run of numbers. Look at the highlighted cells or the range shown in the formula before accepting it. If the selection is correct, press Enter. If it is too short, too long, or includes a heading or an existing total, edit the range before pressing Enter. The toolbar saves typing, but it does not know which values you intend to count.
Enter a formula yourself when you want to control the range. With a heading in A1, values in A2:A20, and the total in A21, click A21 and type =SUM(A2:A20), then press Enter. The result is the sum of the numeric values in A2 through A20. Replace the row numbers with the actual first and last rows in your sheet. The colon means the range includes every cell from its starting reference to its ending reference. You can also select the cells with the mouse while entering the formula, rather than typing the range.
Use an open-ended range for values that will keep growing. If A1 is the heading and the values begin in A2, place the total in a different column or on another sheet, not in column A. In that layout, enter =SUM(A2:A) in the result cell. The formula sums the values from A2 to the bottom of column A, so new numbers entered farther down are included without changing the range. Do not put this formula in A21 or another cell in column A: because the range includes that cell, the formula would refer to itself and cause a circular dependency.
Confirm the result and check the range. Click the result cell and inspect the formula bar. Make sure the formula starts with an equals sign and that the selected range covers exactly the intended rows. Compare the displayed total against a small hand-check, such as adding two or three sample values. If the sheet uses a filter, remember that SUM adds matching numeric cells whether or not some rows are hidden by the filter; use a different approach if you specifically need a visible-rows-only total.
Test what happens when the data changes. Change one included number briefly and confirm the total changes, then undo or restore that value. A fixed range such as A2:A20 will not automatically extend to A21 just because you type a new value there. An open-ended range in a separate result cell will include it. If you use the toolbar’s suggested sum, check its range again whenever you extend the list.

Common Mistakes

Including the total cell in its own range. If a formula is in A21, a range such as A2:A21 includes A21 itself. This creates a circular reference rather than a useful total. End a below-the-list range at A20, or keep a whole-column-style total outside column A.

Assuming the suggested range is always right. The SUM toolbar option often detects nearby numbers, but blank rows, text, multiple blocks of data, or a previous total can lead it to suggest the wrong cells. Read the highlighted range before you confirm. If the column has gaps, manually select the complete intended range or enter its start and end references yourself.

Entering numbers as text. Values pasted from a website or imported from another system may look like numbers but be stored as text. SUM may ignore text values in a referenced range, leaving a total that is lower than expected. Check the alignment and number format, and try re-entering a sample value or converting the affected cells to numbers.

Using a fixed range and expecting it to grow. A formula that ends at row 20 only sums through row 20. New entries below that boundary are not part of the formula unless you extend the range or use an open-ended range from a separate cell.

Mixing headings, subtotals, and detail values. A heading is generally ignored as text, but adding both detail rows and subtotals can count the same amounts twice. Decide whether the total should sum the individual entries or the subtotal rows, and include only one level.

Tips

Give the total a clear label, such as Total, in a neighboring cell. This makes it easier to tell the result apart from the last data entry and helps prevent someone from typing over the formula. You can format the result as currency, a percentage, or another suitable number format without changing the calculation. Use Format > Number and select the appropriate format.

For a list that grows regularly, put the total in a summary area above the list, beside it, or on a separate sheet, then use an open-ended range that begins below the heading. That arrangement avoids moving the formula every time rows are added and prevents the total from being counted as an input. Keep the column consistent: one kind of value per column makes both the formula and later checks easier.

For a short, stable list, a fixed range is often clearer than summing an entire column. It documents exactly which rows are included and can avoid accidentally adding unrelated values lower in the sheet. If you insert rows within the selected range, Sheets generally adjusts references to keep the range aligned, but still verify the formula after reorganizing the data.

Google Sheets is being used here in a web browser. Excel has a similar AutoSum feature, but its button is on the Home tab, and menu locations differ. The basic SUM formula works in both programs; the key in either one is to keep the formula cell outside any range that includes the formula itself.

Troubleshooting

The result is zero or smaller than expected: Click a few values that seem to be missing and inspect whether Sheets treats them as numbers. Re-enter one value directly, or use Format > Number to apply a numeric format; formatting alone may not convert text that only looks like a number. Also verify the range starts at the first data row and ends at the last one.

You see a circular dependency warning: The formula range probably includes the cell containing the formula. Move the result to another column or sheet, or shorten the range so it ends at the row before the total. Do not enable iterative calculation just to hide this problem; a simple column sum should not need a circular reference.

The total does not change after adding a row: Click the formula cell and inspect its ending reference. If it ends at row 20 and your new value is in row 21, extend the range or move to an open-ended range stored outside the source column. If you used the toolbar, it may have created a fixed range that needs updating.

The toolbar’s SUM option is missing or its suggestion is wrong: Confirm that you are editing a cell in Google Sheets rather than viewing a read-only file or a different spreadsheet application. You can always type the SUM formula into an editable cell. Check that you have permission to edit the file and that the cell is not protected.

The formula appears as text instead of a result: Make sure it begins with an equals sign and that there is no apostrophe before it. If the cell is formatted as plain text, change it to Format > Number > Automatic, then edit the formula and press Enter again.

Frequently Asked Questions

Can Google Sheets automatically include new numbers in a column total?
Yes. Put the result outside the source column and use an open-ended SUM range beginning at the first data row. For example, with a heading in A1 and values starting in A2, =SUM(A2:A) includes later values entered in column A. Keeping the result outside A avoids a circular reference.

Can I put the total directly below the numbers?
Yes, when the list has a known end. If the values occupy A2:A20, place the total in A21 and sum A2:A20. Do not include A21 in the formula. For a list that may grow, keep the total elsewhere or update its range as entries are added.

Does SUM ignore blank cells and text?
SUM ignores blank cells and text in a referenced range, while adding numeric values. That is useful for a heading or empty rows, but it can make a total seem too low if numeric-looking entries are actually stored as text.

Will the total include filtered or hidden rows?
Yes. SUM normally includes numeric cells in its range even when rows are hidden or excluded from view by a filter. If you need a total that changes according to which rows are visible, use a function designed for visibility-based calculations rather than assuming SUM will do that.

Can I use AutoSum on a phone or tablet?
The steps above describe Google Sheets in a web browser, where the toolbar’s Σ Functions menu is available. In the mobile app, controls can differ by device and app version; entering a SUM formula directly into an editable cell is a practical alternative.

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.