Use `SUMIFS` to add values that meet multiple criteria
Syntax: `=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)`
Select the range of numbers you want to sum as `sum_range`
Select the range to test the first condition as `criteria_range1`
Enter the first condition as `criteria1`
Add more `criteria_range` and `criteria` pairs for additional conditions
Make sure all criteria ranges are the same size as the sum range
Use cell references in criteria to make formulas dynamic
Use comparison operators like `”>100″` or `”<>“` when needed
Use text criteria in quotes, such as `”Apples”`
Use wildcards like `*` and `?` for partial matches
Press Enter to calculate the result
Example: `=SUMIFS(C2:C10, A2:A10, “East”, B2:B10, “Apple”)`
Example: `=SUMIFS(D2:D20, B2:B20, F1, C2:C20, G1)`