How to auto sum in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Steps
-
1
Click the result cell.
-
2
Type =SUM( and select the range.
-
3
Press Enter.
-
4
Use SUMIF if you need criteria.
Related tutorials
These videos might help you go deeper on this topic.
Google Sheet Basics - The Absolute Basics
Related blog posts
Written guides that go deeper on this question.
How To Hide Data with Checkboxes in Google Sheets
Google Sheets, Google Sheets Tutorials | This tutorial is meant to show you not just what magical things you can do with checkboxes, but also to show you my process on how when you become a member of Better Sheets.
Read post →Why Should I Code in Google Sheets?
Automate repetitive tasks, such as data entry, calculations, and formatting in Google Sheets.
Read post →Getting Started in Google Sheets Spreadsheet Management
Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Explore tab
The Explore tab is a sidebar panel that analyzes your selected data and suggests charts, pivot tables, formatting, an...
Open →SUMIF
SUMIF totals values in a sum_range when a matching row in criteria_range meets your criterion. It is the classic sing...
Open →SUMIFS
SUMIFS adds values in sum_range only when every criteria_range passes its paired test. Argument order is sum_range fi...
Open →SUM()
Google Sheets SUM() function guide
Open →SUMIF()
Google Sheets SUMIF() function guide
Open →SUMIFS()
Google Sheets SUMIFS() function guide
Open →Related questions
How to sum columns in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →How to find sum on Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →How to sum a column in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →How to sum rows in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →How to find the sum in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →Where is auto sum in Google Sheets
Click the cell for the total and enter =SUM(range), for example =SUM(A2:A100). Or select the numbers and read the sum in the bottom-right explore/status area, then click it to paste. SUM ignores text; use SUMIF/SUMIFS when you need conditions.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.