SUMIF
Math FormulasLearn SUMIF to sum cells based on criteria. Master single-condition summing with text, numbers, dates, and wildcards.
Syntax
SUMIF(range, criteria, [sum_range])Parameters
rangeThe range of cells to evaluate against the criteria
criteriaThe condition that determines which cells to sum
sum_rangeThe actual cells to sum (optional, defaults to range)
Examples
=SUMIF(A:A, "Apple", B:B)Sum column B where column A equals 'Apple'
=SUMIF(B:B, ">100")Sum all values in column B greater than 100
=SUMIF(A:A, "*phone*", B:B)Sum where column A contains 'phone'
Common Errors
Returns 0 if no matches found
#VALUE! - Criteria is invalid
Pro Tips
Use wildcards * and ? for partial matches
Criteria with operators must be in quotes
For multiple criteria, use SUMIFS
Related Functions
Need Help with SUMIF?
Describe your specific use case and our AI will generate the perfect SUMIF formula for you.
Generate SUMIF Formula