SUMIF and SUMIFS: Conditional Summing

SUMIF - Single Condition

Syntax

=SUMIF(range, criteria, [sum_range])

Examples

• =SUMIF(A:A, "Apple", B:B) - Sum column B where A equals "Apple"
• =SUMIF(B:B, ">100") - Sum values greater than 100
• =SUMIF(A:A, "*phone*", B:B) - Sum with wildcard matching

SUMIFS - Multiple Conditions

Syntax

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)

Examples

• =SUMIFS(C:C, A:A, "Sales", B:B, ">1000")
• =SUMIFS(D:D, A:A, "East", B:B, "Q1")

Criteria Options

Type	Example
Exact text	"Apple"
Numbers	100
Comparisons	">100", "<50"
Wildcards	"*", "?"
Cell references	A1

Related Functions

• COUNTIF / COUNTIFS
• AVERAGEIF / AVERAGEIFS
• MAXIFS / MINIFS

Conclusion

These functions are essential for data analysis and creating dynamic reports.