Use `SUMIF` to add values that meet one condition
Syntax: `=SUMIF(range, criteria, [sum_range])`
`range` is the cells to check against the condition
`criteria` is the condition to match
`sum_range` is the cells to add; if omitted, Excel sums the cells in `range`
Example: `=SUMIF(A1:A10, “Apples”, B1:B10)`
This sums values in `B1:B10` where `A1:A10` equals `Apples`
Example: `=SUMIF(C1:C20, “>100”)`
This sums values in `C1:C20` that are greater than 100
Use cell references in criteria, such as `=SUMIF(A1:A10, E1, B1:B10)`
Use wildcards like `*` and `?` in text criteria
Example: `=SUMIF(A1:A10, “App*”, B1:B10)`
Use comparison operators in quotes, such as `”>=50″` or `”<>“&D1`
Press Enter after typing the formula to get the result