Beginner
Statistical
SUMIF
Adds the numbers in a range that meet a single condition.
Compatibility: All Excel versions
Syntax
=SUMIF(range, criteria, [sum_range])
Example
=SUMIF(A:A,"Rent",B:B)
When to Use It
Use SUMIF to total a subset of data — e.g. total spending in just the "Rent" category from a longer list of mixed expenses.