Formulas > =SUMIFS()
How to Use SUMIFS() in Google Sheets
Description
How To Actually Use SUMIFS() in Sheets
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Try SUMIFS yourself
In cells A1:A10, you have sales amounts, and in cells B1:B10, you have the corresponding product categories. Use the SUMIFS formula to calculate the total sales for the category 'Electronics' in cell D1.
Hints (3)
-
Remember to specify the sum range first.
-
Make sure to match the criteria with the correct range.
-
Use quotation marks for the text criterion.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for SUMIFS(). Click through to watch.
How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria
Learn more about the SUMIFS() formula:
Generate a SUMIFS() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses SUMIFS(). 2 free AI generations, no signup. Members get unlimited use.
Generate a SUMIFS() formula