SUMIF Formula Generator
SUMIF adds up values in a range that meet one specific condition. Use it to total sales by region, expenses by category, or any single-criterion sum.
Syntax
=SUMIF(range, criterion, [sum_range])Try it — generate a SUMIF formula
Examples
Sum sales for one region
=SUMIF(A:A, "North", B:B)Adds every value in column B where the same row in column A equals "North".
Sum amounts over $100
=SUMIF(B:B, ">100")Adds every value in column B greater than 100. No sum_range needed — range IS the sum.
Sum matching partial text
=SUMIF(A:A, "*widget*", B:B)Wildcards: sum B where A contains "widget" anywhere.
Tips
- ✓For multiple conditions use SUMIFS instead. SUMIF handles only one.
- ✓Wrap numeric criteria in quotes: ">=100", not >=100.
- ✓Omit sum_range when the criterion range IS what you want to sum.
Related Formulas
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
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...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free