SUMIFS Formula Generator
SUMIFS adds up values that meet multiple criteria. It's essential for financial reports, sales analysis, and any situation where you need conditional totals.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)Try it — generate a SUMIFS formula
Examples
Total sales for West region in Q1
=SUMIFS(D:D, B:B, "West", C:C, "Q1")Sums column D where column B is "West" AND column C is "Q1".
Sum orders above $1000
=SUMIFS(C:C, C:C, ">1000")Sums all values in column C that are greater than 1000.
Revenue by product and date range
=SUMIFS(E:E, B:B, "Widget", A:A, ">="&DATE(2024,1,1), A:A, "<="&DATE(2024,3,31))Sums revenue for "Widget" between Jan 1 and Mar 31, 2024.
Tips
- ✓Unlike SUMIF, SUMIFS puts the sum_range first, then the criteria pairs.
- ✓Use comparison operators in quotes: ">100", "<>0", ">=2024-01-01".
- ✓You can use cell references in criteria: ">"&A1 to compare against a cell value.
Related Formulas
COUNTIFS
COUNTIFS counts cells that meet multiple criteria across different columns. Perf...
AVERAGEIFS
AVERAGEIFS calculates the average of cells that meet multiple criteria. Useful f...
SUMPRODUCT
SUMPRODUCT multiplies corresponding elements in arrays and returns the sum. It's...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free