How to SumIFS in Excel:
In this video tutorial I will cover using the sumifs function in Microsoft Excel.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
The SUMIFS function syntax has the following arguments:
- Sum range (Required). The range of cells to sum.
- Criteria_range1 Required. The range that is tested using Criteria1.Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.
- Criteria1 (Required). The criteria that defines which cells in Criteria_range1 will be added. For example, criteria can be entered as 32, “>32”, B4, “apples”, or “32”.
- Criteria_range2, criteria2, … (Optional) Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.
3