Google Sheets: How to Add Up a Column of Numbers

If your numbers are in B2:B10, enter =SUM(B2:B10) in an empty cell to add them; Google Sheets displays the total there. Replace the range with the cells in your sheet, or use a whole-column reference when appropriate.

How the SUM formula works

SUM adds numeric values from the cells or ranges you give it. Every formula begins with an equals sign, and the range between the parentheses tells Sheets what to include. In the example above, the colon means “from B2 through B10,” including both endpoints and every cell between them.

For a concrete example, suppose B2:B5 contains 12, 8, 15, and 5. With those values in B2:B5, enter =SUM(B2:B5) in an empty cell; the result is 40. If the numbers are in another column, change the letter: for values in C2:C5, use =SUM(C2:C5). You can also select non-adjacent cells or ranges, separated by commas. For example, if B2:B4 and B7 contain numbers, =SUM(B2:B4,B7) adds those four cells and leaves B5:B6 out.

SUM can also accept individual numbers, but a cell range is usually easier to maintain. When entries change, the result recalculates automatically. That makes a formula preferable to typing a total by hand, especially in a sheet that other people will update.

Choose a range or the entire column

A bounded range such as B2:B100 is clear and limits the calculation to the rows you expect to use. It is a good choice for a fixed table, a monthly report, or a sheet where totals sit near the data. If the list may grow, you can sum from the first data row down to the bottom of the column.

With headers in row 1 and numbers beginning in B2, enter =SUM(B2:B) in a cell outside column B; it adds values from B2 downward, including later entries. This open-ended range avoids editing the formula whenever you append rows. Alternatively, =SUM(B:B) sums the entire B column, including any numeric values above or below the main table. Put that formula in another column or on a summary sheet: placing it in column B would make the range include the formula itself and cause a circular reference.

Whole-column formulas are convenient, but they are not always the best layout. A bounded range helps prevent unrelated numbers lower down from being included. For a large or shared workbook, keeping source data in a clean table area and displaying totals in a separate summary area makes the calculation easier to review.

Add a column using the Sheets menus

You do not have to type the formula from memory. In Google Sheets in a web browser, select the empty cell where the total should appear, choose Insert > Function > SUM, and then select the cells to add. Press Enter to complete the formula. The menu creates a SUM formula in the selected cell; check that its range covers the intended data before relying on the result.

You can also type an equals sign and the function directly, then select the range with your mouse while editing the formula. For example, type =SUM(, drag over B2:B10, type the closing parenthesis, and press Enter. This is often the quickest approach when the data is visible and contiguous.

To place the total at the bottom of a list, click the first blank cell beneath the values and use a range ending at the row above. If the total is in B11 and the data occupies B2:B10, enter =SUM(B2:B10). Do not include B11 in that range, or the formula will refer to itself.

Make totals include new rows

When rows are added over time, an open-ended range can save maintenance. With a heading in B1 and data starting in B2, the formula =SUM(B2:B) includes new numbers entered farther down column B. Keep the formula outside that column, or use a separate summary tab, so it does not include itself.

Another option is to leave a sufficiently large bounded range, such as B2:B500, if you know the approximate maximum size and want to keep the formula away from unrelated cells. This can be easier to audit in a fixed template. The trade-off is that data entered below row 500 will not be counted until you expand the range.

Consider what happens when users insert rows, paste data, or add notes beneath the list. A whole-column sum will include any numeric entry in that column, not just records that belong to the table. A clear data boundary, a dedicated total row, and consistent column use reduce the risk of an accidental extra amount.

Sum only rows that meet a condition

A plain SUM adds every number in its range. If you need a subtotal for one category, use SUMIF, which adds values only when corresponding cells meet a condition. For instance, suppose A2:A6 contains category names and B2:B6 contains amounts, while D1 contains the category North. Enter =SUMIF(A2:A6,D1,B2:B6) in an empty cell; it adds the amounts on rows whose category matches D1. If the matching amounts are 10 and 7, the result is 17.

In SUMIF, the first range is checked for the condition, the second argument is the criterion, and the final range supplies the numbers to add. When the criterion is a cell reference such as D1, the formula can be reused by changing the value in D1. This is useful for totals by department, product, or status without manually filtering and adding rows.

For multiple conditions, Google Sheets provides SUMIFS. It can sum amounts where, for example, a department matches one cell and a date falls within a chosen period. Take care to use matching-sized criteria ranges and sum ranges. If the task is simply to total one uninterrupted column, however, SUM is simpler and easier to check.

Check why a total looks wrong

If a total is unexpectedly low or zero, check the range first. The selected range may stop before the last data row, start below the first value, or point to the wrong column. Click the formula cell and review the colored range outline in the sheet. Also check whether some apparent numbers are stored as text, perhaps because they were imported with unusual separators or a leading apostrophe. SUM generally ignores text in referenced cells rather than treating it as a number.

If the result is too high, look for extra numeric values inside the range: an earlier subtotal, a note containing a number, or values from a second table lower in the same column. Including a subtotal in another SUM can double-count the underlying entries. Make sure a whole-column formula is not being used where the column contains more than the intended data.

Formula shows as text: Check that the cell does not have a leading apostrophe and that the entry begins with an equals sign. If the cell is formatted as plain text, change its number format and re-enter the formula.
Circular dependency warning: Move the formula outside the range it sums. A formula in B11 should not use a range such as B:B that includes B11.
Unexpected decimal places: The stored total may be correct but displayed with limited precision. Use the toolbar’s increase or decrease decimal places controls, or choose Format > Number to adjust how the result appears.
Formula parse error: Check for a missing parenthesis, an invalid range, or punctuation copied from a document. Use a colon between range endpoints, as in B2:B10.

Formatting changes how a value appears, not the underlying sum. Applying currency or number formatting can make a total easier to read, but it does not repair text values or change which cells the formula includes.

What SUM includes—and what it does not

SUM adds numeric values in the referenced cells and ignores blank cells and text. A heading inside a range therefore does not normally disrupt the result, although keeping headings outside the data range makes the formula clearer. Dates and times in Sheets are stored as numeric values, so including them in a sum can produce a number that is technically valid but not meaningful for the question you intended to answer.

A standard SUM is not a “visible rows only” calculation. If you filter a table, the formula can still include matching numbers in rows hidden by the filter. If the goal is a total that responds to filtered or manually hidden rows, look into the SUBTOTAL function and choose its function number according to the behavior you need. Do not assume that applying a filter changes an ordinary SUM.

Likewise, SUM does not check whether repeated entries are duplicates or whether a value belongs to the right category. It performs arithmetic on the cells in its range. Data validation, careful source data, and criteria-based functions address those separate problems.

Google Sheets and Excel differences

The basic formula =SUM(B2:B10) works in both Google Sheets and Excel. The colon range notation and the SUM function are standard in both applications, so a simple total can usually be copied between them without changing the formula.

The steps above refer to Google Sheets in a web browser, not Excel’s ribbon. Sheets has its own menus and interface, and menu wording or placement can change over time. In Excel, the equivalent function is also SUM, but you would use Excel’s formula tools and ribbon rather than Google Sheets’ Insert > Function menu. Excel keyboard shortcuts and platform details are separate from the browser steps described here.

Sheets is designed for collaborative editing in the browser, so several people may update a source range while a total recalculates. That convenience makes a clearly labeled total cell and an understandable range especially valuable. A collaborator should be able to tell at a glance which entries are included.

Frequently Asked Questions

How do I sum an entire column in Google Sheets?
For numbers beginning in B2, enter =SUM(B2:B) in a cell outside column B. To include every cell in B, use =SUM(B:B), but do not put that formula in column B because it would include itself.

Can I use AutoSum in Google Sheets?
You can create a total with the SUM function through Insert > Function > SUM, or type the formula directly. The exact menu is not Excel’s AutoSum ribbon button; selecting the correct range is still important whichever method you use.

Why is SUM ignoring some numbers?
Those entries may be stored as text rather than numeric values, or they may fall outside the formula’s range. Check the cell contents and the range highlighted when you edit the formula. Imported values with inconsistent separators can also need cleanup.

Does SUM include filtered-out rows?
Yes. A regular SUM adds numbers in its referenced range even when some rows are hidden by a filter. Use SUBTOTAL when you specifically need a total that responds to filtered or hidden rows, and select its behavior carefully.

Can I add numbers from two columns?
Yes. For example, if the values are in B2:B10 and C2:C10, use =SUM(B2:B10,C2:C10) in an empty cell. It adds both ranges; check that neither range includes a subtotal you have already counted.

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.