SUMIFS Function - Excel
Overview
The SUMIFS function in Excel is a useful tool for adding up a range of numbers based on multiple specified conditions or criteria. This function allows you to apply multiple criteria and adds up only the cells that meet all the specified conditions.
Example:
=SUMIFS(C2:C11, D2:D11, "lion", E2:E11, "run")
Syntax:
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
sum_range: The range of cells to sum.
criteria_range1, criteria_range2, ...: The ranges where the criteria are applied.
criteria1, criteria2, ...: The conditions that determine which cells to include in the sum for each corresponding criteria_range.
Example
In the example above, the SUMIFS function will add up the numbers in range C2:C11 for those that meet the criteria in range D2:D11 and E2:E11. The criteria for range D2:D11 is that it must equal “lion” and the criteria for range E2:E11 is that it must equal “run”. The final output of the function is 7 because the only numbers that met the criteria were 1 and 6 and that is what they add up to.