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: