What is SUMIF?
Adds cells that meet a single criterion. The go-to function for conditional totals like summing sales by region or category.
Syntax
=SUMIF(range, criteria, [sum_range])
Example
Formula: =SUMIF(A2:A10, \
Result: 150
How It Works
Sums values in B2:B10 where corresponding cells in A2:A10 equal 'Apples'. If sum_range is omitted, Excel sums the cells in the criteria range itself.