Formula Guide
SUMIFS Formula Builder
SUMIFS adds up values that meet multiple criteria. It's essential for financial reports, sales analysis, and any data that needs conditional totaling.
What It Does
Sums values in a range that meet one or more criteria across different columns.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Example
Example: Sum sales for West region in January =SUMIFS(D2:D100, B2:B100, "West", C2:C100, "January") Data: | Date | Region | Month | Sales | | 1/5 | West | January | 5000 | | 1/12 | East | January | 3000 | | 1/20 | West | January | 7000 | Result: 12000
Pro Tips
- Unlike SUMIF, SUMIFS puts the sum range FIRST
- You can use comparison operators: ">1000", "<>0", ">="&A1
- Use wildcards: "*text*" for partial matches
- Combine with date criteria for powerful reporting
Try the AI SUMIFS Generator
Pre-filled with: “Sum all values where the region is West and the month is January”