Excel SUMIFS function

Function              SUMIFS

Description        Excel SUMIFS function sums the value of those cells within a range which meets multiple criteria.

Syntax  SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

sum_range  The range to be summed.

criteria_range1  This is the first range to evaluate.

criteria1  The criteria which to be used on criteria_range1.

criteria_range2  [optional] This is the second range to evaluate.

criteria2  [optional] The criteria which to be used on criteria_range2.

Related Video Tutorials: