How to Sum a Column in Google Sheets: Formulas and Tips

To sum a column in Google Sheets, enter =SUM(B2:B12) in an empty cell, replacing B2:B12 with the range that contains your numbers, then press Enter. To total every value in column B, use =SUM(B:B) in a cell outside column B.

Use SUM to add a selected range

SUM is the standard Google Sheets function for adding numbers. The part inside the parentheses tells Sheets which cells to include. A colon between two cell references means the range from the first cell through the second, including both endpoints. In the opening example, the function adds every numeric value from B2 through B12.

To enter a formula in the browser version of Sheets:

Click the cell where you want the answer to appear.
Type the formula, beginning with an equals sign. For example, with amounts in B2:B12, enter =SUM(B2:B12).
Press Enter. The cell displays the total, while the formula remains visible in the formula bar when that result cell is selected.

The function name is not case-sensitive, so =sum(B2:B12) works too. You can type the range reference or select the cells with your mouse after typing the opening parenthesis. A header row is usually left out of a range such as B2:B12, although SUM ignores text in a referenced range and therefore will not add a text heading.

Sum an entire column

A whole-column reference is useful when the list may grow and you do not want to update a range each time you add a new row. With amounts stored anywhere in column B, put the formula in a different column, such as D1, and enter =SUM(B:B). This includes numeric values throughout B, including values entered below the rows currently in use. Blank cells and text entries do not contribute to the total.

Keep the result cell outside the column being summed. If you put =SUM(B:B) in column B, the formula refers to the cell containing itself, creating a circular reference. For a neatly arranged sheet, many people put the total in a summary cell above or beside the data, or use a finite range when they know where the list ends.

A full-column sum can be convenient, but it is not automatically the best choice for every workbook. If the column also contains unrelated numbers farther down, those values will be included. A finite range makes the intended data boundary explicit, while a full-column reference is more forgiving when rows are appended. Choose based on how the sheet is structured.

Choose the right range for your data

The range should match the records you intend to total. If row 1 contains labels and the data runs from rows 2 through 50, sum B2:B50 rather than including an unrelated summary or notes section. When adding a total row immediately below the data, a finite range can keep the calculation clear. For example, if amounts are in B2:B12 and the total goes in B13, use =SUM(B2:B12) in B13.

If the values you need are in separate blocks, SUM can accept multiple ranges. With one set of amounts in B2:B6 and another in D2:D6, enter =SUM(B2:B6,D2:D6) in a cell outside those ranges. Sheets adds the values from both blocks and returns one combined total. This can be easier to audit than adding several separate SUM results together.

Before building a formula, check that the column contains only values relevant to the calculation. A full-column formula is simple, but it cannot distinguish sales figures from a note or a second table later in the same column. A carefully selected range can prevent accidental inclusion of unrelated data.

Use the menu or status bar for a quick check

You do not have to memorize the function name to insert it. In Google Sheets in a web browser, select the destination cell and use Insert > Function > SUM, then fill in the range in the formula. Menu organization can change over time, so typing the formula directly is often the quickest and clearest approach.

For a temporary check, select the numeric cells you want to total. Google Sheets can show a Sum value in the status area at the bottom of the window when a suitable range is selected. This is handy for a quick look, but it is not a formula placed in a cell; it will not become part of the sheet’s calculations or update as a saved total. Use SUM in a cell when the result needs to remain visible or feed another formula.

Keep totals useful as data changes

A formula recalculates when values in its referenced cells change. If the formula is =SUM(B2:B12), edits to those cells affect the result, but a new value entered in B13 is outside that specified range. You can extend the formula’s endpoint, or use a whole-column reference if the entire column is dedicated to those amounts.

For recurring work, structure the sheet so the data stays together: keep one header row, put each record on its own row, and avoid placing notes or a second table underneath a column that is summed in full. If the total must be next to the data, a finite range is especially helpful. It makes it easier to see which rows the calculation covers and reduces the risk of summing a separate section by mistake.

Google Sheets also adjusts many cell references when rows are inserted or deleted, but it is still worth checking totals after changing the layout, moving data, or pasting in a new block. A formula that is syntactically correct can still point to the wrong cells if the sheet’s organization has changed.

What SUM includes when rows are filtered

SUM adds numeric values in its referenced cells whether or not those rows are hidden by a filter. That distinction matters in a sales or inventory sheet: filtering the display to show one category does not, by itself, make a regular SUM show only that category’s subtotal. The formula continues to include the other values in its range.

For a total that responds to filtered-out rows, use SUBTOTAL. With values in B2:B12, enter =SUBTOTAL(9,B2:B12) in a cell outside the range. The function number 9 requests a sum, and SUBTOTAL is designed to exclude rows removed by a filter. This is useful for viewing a subtotal as you change a filter. It is not a replacement for every SUM: if you want the total of all records regardless of the current filter, use SUM instead.

For clarity, label the result according to what it represents, such as All records or Visible rows. That small note prevents readers from confusing an all-data total with a filtered subtotal when they inspect the sheet later.

Fix common SUM problems

If the result is zero or smaller than expected, first check the range and the values themselves. SUM adds numbers, not text that merely looks like numbers. Imported data can contain values stored as text, leading or trailing spaces, or symbols that prevent Sheets from recognizing the entries as numeric. Select a few suspect cells and inspect their contents or formatting; changing the display format alone does not always convert text into numbers.

Other common issues include:

Wrong endpoint: A formula ending at B12 will not include a new value in B13. Expand the range or choose a whole-column reference if appropriate.
Wrong column: Confirm that the formula points to the amount column, not a nearby ID, date, or quantity field.
Unintended extra values: A whole-column formula includes every numeric value in that column, not just the visible table.
Circular reference: Do not place a full-column sum inside the same column it sums. Move the result cell elsewhere or use a range that ends before the total cell.
Filtered rows: A regular SUM includes values hidden by a filter. Use SUBTOTAL when the total should follow the filter.

If Sheets displays a formula parse error, check for a missing parenthesis, colon, or range endpoint. The examples here use commas between function arguments. Spreadsheet locale settings can affect which argument separator is accepted, so if a formula copied from elsewhere fails to parse, check the sheet’s locale and use the separator expected by that setting.

SUM compared with manual addition

You could add individual cells with an expression such as =B2+B3+B4, but SUM is usually safer for a list. With a range, the formula is shorter, and adding rows is easier to manage. Manual addition also makes it easier to omit a cell or include one twice as the list changes. Use direct addition only when the calculation genuinely combines a small number of distinct cells and the intent is clear.

SUM is also different from a filter-aware subtotal. Use SUM when the goal is to total the specified cells regardless of filtering; use SUBTOTAL when the displayed rows should determine the result. Neither function can decide which records are meaningful: selecting the right range and checking the data remain your responsibility.

Frequently Asked Questions

What is the formula to sum a column in Google Sheets?

For a range, use =SUM(B2:B12), replacing the range with your data’s cells. For all of column B, use =SUM(B:B) in a cell outside column B.

How do I sum a column without including the header?

Start the range at the first row of data rather than the heading. For example, if the heading is in B1 and amounts begin in B2, use =SUM(B2:B12) for those twelve rows of data.

Why is my Google Sheets sum showing zero?

The range may be wrong, or the apparent numbers may be stored as text. Check that the formula references the intended cells and that the entries are recognized as numeric values; changing a cell’s number format by itself may not convert text.

Does SUM include filtered or hidden rows?

SUM includes values in its range even when rows are hidden by a filter. To total the rows remaining visible after filtering, use a SUBTOTAL formula such as =SUBTOTAL(9,B2:B12).

Can I sum two separate ranges?

Yes. With values in B2:B6 and D2:D6, use =SUM(B2:B6,D2:D6). The formula adds both ranges and returns a single result.

Choose a formula that matches the task

For most column totals, start with SUM and a range that covers exactly the records you want. Use a full-column reference when new entries should be included automatically and the column is reserved for that data. If the total should change with a filter, use SUBTOTAL instead. These choices keep the formula simple while making clear what the displayed number represents.

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.