Better Sheets

How to Use SUM() in Google Sheets

Description

Returns the sum of a series of numbers and/or cells.

How To Actually Use SUM() in Sheets

SUM(value1, [value2, ...])

Try SUM yourself

Sum every value in A1:A10.

Your formula

Hints (1)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

COUNTA() IF() INDEX() ISBLANK() SUM()

Build The Dashboard - Design a Better Dashboard Part 3

We're actually gonna go build the dashboard today.

CHAR() COUNTA() HYPERLINK() IF() INDEX() +2 more

Bjarne Asks: Can I show the total number of rows minus the header row?

find out how to show the total number of data rows available in a sheet.

Beginner

COUNTA() COUNTBLANK() SUM()

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().

FILTER() FLATTEN() SORT() SUM() UNIQUE()

Figuring out the 80/20 Rule with a Running Sum Total

I figured out that 20% of my videos are getting 80% of the watch time on my YouTube channel, and I actually used a Google sheet to figure this out.

Beginner

SUM()

Visicalc 2023 Quick Walkthrough

This is a fun template I created for April 1st. Take a quick walk through the features here. And get yourself a copy of the sheet below.

Beginner

SUM()

How to Count Numbers in a Row

Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.

Beginner

AND() COUNT() COUNTA() COUNTIF() FILTER() +1 more

Invoicing in Google Sheets for Freelancers

Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.

Beginner

FILTER() IFNA() SUM()

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double counted in attendee lists.

Beginner

COUNTUNIQUE() COUNTUNIQUEIFS() FILTER() SUM() UNIQUE()

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.

Intermediate

SORT() SUM() SUMIF() UNIQUE()

Daily Writer's Word Count Tracker

Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.

Intermediate

CONCATENATE() COUNTIF() ROUND() SUM() TEXT() +1 more

How to Filter Multi-Select Dropdown Feature

Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!

Intermediate

FILTER() SEARCH() SUM()

Expense Tracker Template with Data Entry Form Inside Sheets

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.

Intermediate

FILTER() IFNA() SUM()

Better Domain Portfolio Template

Create a better list of domains.

Intermediate

COUNTA() FILTER() INDEX() MATCH() MAX() +1 more

Transcript-matched member videos for SUM(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Unlock these tutorials

Learn more about the SUM() formula:

Generate a SUM() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses SUM(). 2 free AI generations, no signup. Members get unlimited use.

Generate a SUM() formula

How to Use SUM() in Google Sheets

Try SUM yourself

Create an Auto-Update Sales Chart: Trailing 12 Months

Build The Dashboard - Design a Better Dashboard Part 3

Bjarne Asks: Can I show the total number of rows minus the header row?

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

Figuring out the 80/20 Rule with a Running Sum Total

Visicalc 2023 Quick Walkthrough

How to Count Numbers in a Row

Invoicing in Google Sheets for Freelancers

Count Unique Attendees For Each Event

Americano Tournament Template With Four Automations

Daily Writer's Word Count Tracker

How to Filter Multi-Select Dropdown Feature

Expense Tracker Template with Data Entry Form Inside Sheets

Better Domain Portfolio Template

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Write Apps Script to Create a New Google Sheets Formula

Calculate ROAS in Google Sheets

Google Sheet Basics - The Absolute Basics