If you need to calculate total in Google Sheets, the fastest way is to use a SUM formula and point it at the cells you want added together. That works for sales, expenses, inventory counts, time logs, and any list of numbers you need to total in a sheet. Once you know the basic formula, you can total a column, a row, selected cells, or filtered data in just a few clicks.
Use SUM to add numbers in Google Sheets
The simplest way to make Google Sheets calculate totals is with =SUM. Put the formula in the cell where you want the result, then select the numbers you want added. Google Sheets returns the total immediately, and the result updates whenever the source cells change.
Total a range of cells
If your numbers are in a single column or row, SUM is the cleanest option. For example, to total cells from A2 through A10, enter =SUM(A2:A10). For a row, use =SUM(B2:F2). This is the standard answer for how to total cells in Google Sheets and how to total numbers in Google Sheets.
- Click the cell where you want the total to appear.
- Type =SUM(.
- Highlight the cells you want to add, or type the range.
- Close the parenthesis and press Enter.
If you need to add total of column in Google Sheets, use the entire range for that column, for example =SUM(C2:C100) or =SUM(C:C) if you want the whole column included.
Use AutoSum for a quick total
AutoSum is the fastest way to get the total in Google Sheets when the numbers are in a continuous block. Click the cell beneath the values, then choose the sigma icon or insert a SUM formula from the toolbar. Sheets suggests the range above the active cell, which saves time on long lists.
This is the easiest method if you want to make Google Sheets total a simple column of expenses, dates converted to numbers, or quantity lists. It also works well when you need to do total on Google Sheets without memorizing formulas.
Total an entire column, row, or selected cells
Different layouts need different ranges. If you want to create a total in Google Sheets for a long list, use a column range. If your data runs left to right, use a row range. If the numbers are scattered, add only the specific cells that belong in the total.
Total one column
To make Google Sheets total a whole column of values, place the formula in a blank cell under the data and reference the column range. For example, =SUM(D2:D) totals everything in column D from row 2 downward. This is useful for ongoing logs where new entries are added below the existing rows.
Total selected cells that are not next to each other
If your numbers are split across the sheet, add each cell or range inside SUM. Use a comma between separate ranges, such as =SUM(B2:B5, D2:D5, F2). That gives you one total without pulling in unrelated values.
This approach answers how to total in Google Sheets when the data is not in a single block. It also works for how to total sum in Google Sheets when you are combining categories like sales, tax, and shipping from separate areas.
Calculate totals with filters, hidden rows, and subtotals
If you filter data and want the total to follow what is visible, use SUBTOTAL instead of SUM. SUM adds every referenced cell, including hidden rows. SUBTOTAL can ignore filtered-out rows, which makes it the right choice for reports and category views.
Use SUBTOTAL for visible rows
Enter =SUBTOTAL(9, A2:A100) to total visible values in that range. The number 9 tells Sheets to use SUM behavior. If rows are hidden by a filter, they are excluded from the total. This is the correct tool when you need to count total in Google Sheets after narrowing a dataset.
Total grouped data with a summary row
For grouped tables, put the formula at the end of each section or in a dedicated summary row. Example: one subtotal for weekly sales, then a final grand total at the bottom. That keeps the sheet readable and makes it clear whether you are showing a section total or the overall total.
If your question is how to get a total on Google Sheets for a filtered list, SUBTOTAL is the answer. If you want the total of everything regardless of filters, use SUM.
Calculate totals for money, time, and percentages
Google Sheets totals work the same way for money, time, and percentages, but the cell format matters. The formula adds the underlying values, then the format controls how the answer appears on screen.
Total money in Google Sheets
For currency totals, enter SUM in the total cell and format the result as currency. For example, =SUM(E2:E20) adds your amounts, then the cell can display dollars, pounds, or euros depending on the format you apply. This is the simplest way to total money in Google Sheets for budgets, invoices, and expense tracking.
Total time in Google Sheets
For hours and minutes, add the cells with SUM and format the result as duration. If you are tracking work time, use a range like =SUM(F2:F15). If the total looks wrong after 24 hours, set the format to duration so Google Sheets displays the full accumulated time correctly.
Total percentages
If you want a percentage total, sum the underlying decimals or percentages and format the result as percent. This works for contribution shares, completion rates, and score breakdowns. For totals that should equal 100 percent, make sure the source values are meant to be added together before using SUM.
Use formulas that update automatically
If you want Google Sheets to make totals automatically as you add data, build formulas that include future rows or use a table-style range. That saves you from editing the formula every time a new line appears.
Total a growing list
Instead of ending the range at a fixed row, use a start-to-open-ended range like =SUM(B2:B). This totals everything from B2 down through any new entries you add later. It is the best choice for logs, order sheets, and inventory counts that expand over time.
Keep a total cell separate from data entry
Place your total in a row below the list or in a summary panel away from the data entry area. Then keep adding numbers above it. That layout makes it obvious where the formula lives and prevents accidental overwriting. It also makes it easy to make Google Sheets calculate totals without manual edits each day.
Fix common total problems
When a total is wrong, the cause is usually text, blank cells, or an incorrect range. Google Sheets does not add text values, and a formula that points to the wrong rows will return the wrong result even if it looks correct at first glance.
Numbers stored as text
If SUM skips a cell, the value may be stored as text. Common causes include leading apostrophes, pasted data from other apps, or numbers formatted incorrectly. Convert the cells to numbers, then re-enter the value if needed. Once the entries are numeric, the total will include them.
Missing cells or extra cells in the range
Check whether the formula range includes every row you want and excludes rows you do not want. A total like =SUM(A2:A10) leaves out A11 and below. If the total seems too low, the range is too short. If it seems too high, the range includes something that should not be counted.
Decimal and separator differences
Some sheets use commas in formulas and commas in numbers, depending on locale settings. If a formula fails to parse, the separator settings may not match your sheet locale. Use the formula style expected by your Google Sheets file so the total calculates correctly.
Frequently Asked Questions
How do I count total in Google Sheets?
If you want the number of filled cells, use =COUNTA(range). If you want to count only numeric cells, use =COUNT(range). COUNT gives you the number of entries, while SUM gives you the total of the values themselves.
How do I add total on Google Sheets for a whole sheet?
Use a column range that covers all the entries you want, such as =SUM(C2:C). If you need one grand total from several sections, add each section range inside the same SUM formula. Keep the total formula outside the data area so new rows do not overwrite it.
How do I get the total in Google Sheets for filtered data?
Use =SUBTOTAL(9, range). This gives you the total for visible rows only and ignores rows hidden by a filter. If you want every row included, use SUM instead.
How do I total numbers in Google Sheets when they are in separate cells?
List each cell or range inside SUM with commas, for example =SUM(A2, C2, E2) or =SUM(A2:A5, D2:D5). This is the cleanest way to total non-adjacent numbers without rearranging your sheet.
How do I make Google Sheets calculate totals automatically when I add new data?
Use an open-ended range like =SUM(B2:B). That formula includes every new number you add below row 2, so the total updates without editing the formula.
Related Posts:
Google Sheets
- How to Search in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Calculate Days Between Dates in Google Sheets
- How to Make a Graph in Google Sheets
- How to Delete or Remove a Filter View in Google Sheets
- How to Change Cell Color With a Formula in Google Sheets
- How to Remove a Drop-Down in Google Sheets
- How to Freeze Rows and Columns in Google Sheets
- How to Change Cell Width in Google Sheets
- How to Convert Google Sheets to Excel
- How to Insert Multiple Rows in Google Sheets
- How to Lock a Formula or Cell in Google Sheets
- How to Sort in Google Sheets (A to Z, by Column)
- How to Add Cells and Columns in Google Sheets (SUM)
- How to View Hidden Sheets and Rows in Google Sheets
- How to Merge Cells in Google Sheets
- How to Insert a Hyperlink in Google Sheets