Taking too long? Close loading screen.


How to SumIFS in Excel:

In this video tutorial I will cover using the sumifs function in Microsoft Excel.


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.
in Basic Excel FunctionsLearn Excel