Google Sheets reference

SUMIFS in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Math & Statisticsintermediate

=SUMIFS($D:$D,$B:$B,$G$2,$C:$C,">="&DATE(2026,1,1),$C:$C,"<"&DATE(2026,2,1))

Also in Excel

See the full SUMIFS reference for Excel — including all worked examples, common errors, and FAQ.