The syntax of ‘SUMIFS’ is as follows:
‘=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)’
Notice that the primary difference compared to ‘SUMIF’ that is immediately obvious is the first, and required, argument in ‘SUMIFS’.
Unlike the ‘SUMIF’ function, ‘sum_range’ in ‘SUMIFS’ is required.
Following this first parameter is the first criteria range and criteria pair, ‘criteria_range1’ and ‘criteria1’.
Clearly, this pair of parameters is required since without at least one of these, the function itself is useless. As requirements present the need for more of these criteria range/criteria pairs, we can add as many as necessary up to the limit of 127 pairs.
The basic gist of how to make use of these parameters holds true to that of ‘SUMIF’, so we will not repeat those same basic concepts.