SUMIF Generator - Sum with Conditions | Excel & Sheets
Adds the cells specified by a given condition or criteria.
Common Errors & Fixes
SUMIF returns 0 or wrong sum
Causes:- Criteria not in quotes for text (e.g. "Apple" not Apple).
- Sum_range and range different sizes; only overlapping rows are summed.
- Number stored as text in range; criteria does not match.
Fixes:- Use quotes for text: ">100", "Sales".
- Make sum_range same size as range, or omit sum_range to sum range.
- Align data types; use VALUE or TEXT as needed.
Frequently Asked Questions
What is the difference between SUMIF and SUMIFS?
SUMIF has one condition; SUMIFS can have multiple conditions. Use SUMIFS when you need to sum only when two or more criteria are met.
Can SUMIF use wildcards?
Yes. Use * for any characters and ? for one character. Example: =SUMIF(A:A,"*apple*",B:B) sums B where A contains "apple".
How do I sum with a date criteria?
Use a cell reference or DATE() in criteria, e.g. =SUMIF(A:A,">="&DATE(2025,1,1),B:B) or =SUMIF(A:A,">="&E1,B:B) where E1 has the date.
Why does SUMIF return 0?
Check that criteria match the data type (e.g. number vs text). Use quotes for text: "=100" or ">50". Ensure sum_range aligns with range if you use it.
When should I use SUMIF vs COUNTIF?
Use SUMIF to add values that meet a condition. Use COUNTIF to count how many cells meet a condition. Both use the same criteria syntax.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More