Master programming syntax, solve interactive challenges & run live code in Syntaxis Explore Arena →

menu_book Course Curriculum (Google Sheets) expand_more

Core Formulas

SUM AVERAGE MIN and MAX COUNT and COUNTA IF IFS AND and OR IFERROR

Lookup & Reference

VLOOKUP HLOOKUP INDEX and MATCH XLOOKUP FILTER SORT UNIQUE INDIRECT

Text & Dates

CONCATENATE / & TEXTJOIN LEFT RIGHT MID SPLIT REGEXEXTRACT DATE TODAY and NOW DATEDIF

Array & Query

ARRAYFORMULA QUERY select QUERY where QUERY group by SUMIF / SUMIFS COUNTIF / COUNTIFS AVERAGEIF SEQUENCE

Data Quality & Analysis

data validation dropdown conditional formatting formula remove duplicates named ranges pivot table concept SPARKLINE percent formatting absolute references

Collaboration & Automation

protected ranges filter views comments and notes IMPORTRANGE GOOGLEFINANCE Apps Script custom function Apps Script onEdit trigger publish/share permissions

Google Sheets / Array & Query

SUMIF / SUMIFS

Learn SUMIF / SUMIFS in Google Sheets with a dedicated explanation, a concept-specific example, practical cautions, and a mastery check.

12 min read • Intermediate

google-sheets-029.txt

text

=SUMIF(B2:B100,"North",D2:D100)
=SUMIFS(D2:D100,B2:B100,"North",C2:C100,"Paid")

What to watch

Content source & attribution

Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

SUMIF / SUMIFS Mastery Check →

COUNTIF / COUNTIFS