Math & Statisticsintermediate
SUMIFS for monthly revenue by category
=SUMIFS($D:$D,$B:$B,$G$2,$C:$C,">="&DATE(2026,1,1),$C:$C,"<"&DATE(2026,2,1))
Function reference
SUMIFS in Excel & Google Sheets
SUMIFS is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 intermediateBuild a custom SUMIFS formula →
When to use SUMIFS
- Build a monthly reporting sheet that totals one category without creating a pivot table first.
Worked examples (1)
Common errors with SUMIFS
Total is zero
Your dates may be stored as text instead of true date values, which prevents the date criteria from matching.
Frequently asked questions
Why use a start date and next-month date?
It creates a clean month window that includes every date in the target month without worrying about month lengths.
Need a custom variation?
Describe your specific SUMIFS problem and get a formula written for your exact data.
Open generator with SUMIFS