Formulas > =SUMIF()
SUMIF Google Sheets Formula
Description
How To Actually Use SUMIF() in Sheets
SUMIF(range, criterion, [sum_range])
Try SUMIF yourself
In the range A1:A10, you have a list of sales amounts. Use the SUMIF formula to calculate the total sales for amounts greater than 100 in the range A1:A10.
Hints (2)
-
Remember to use the correct comparison operator in the criterion.
-
The sum range can be the same as the criteria range if you're summing the same values.
Better Sheets Tutorial
Create a Course Outline in Google Sheets
Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation.
Americano Tournament Template With Four Automations
Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
More related tutorials
Transcript-matched member videos for SUMIF(). Click through to watch.
How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria
How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria
Learn more about the SUMIF() formula:
Generate a SUMIF() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses SUMIF(). 2 free AI generations, no signup. Members get unlimited use.
Generate a SUMIF() formula