SUMIFS Function in Excel

Syntax

=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...)

Arguments

sum_range - The range to be summed

range1 - The first range to evaulate

criteria1 - The criteria to use on range1

range2 - [optional] The second range to evaluate

criteria2 - [optional] The criteria to use on range2

Example

Here we have Sales Table and we have added summary table beside it using the SUMIFS function for all regions where orders are more than 50

Here are the formulas used in the summary table

=SUMIFS($D$2:$D$10,$B$2:$B$10,"East",$C$2:$C$10,">=50")

=SUMIFS($D$2:$D$10,$B$2:$B$10,"Quebec",$C$2:$C$10,">=50")

=SUMIFS($D$2:$D$10,$B$2:$B$10,"Ontario",$C$2:$C$10,">=50")

=SUMIFS($D$2:$D$10,$B$2:$B$10,"West",$C$2:$C$10,">=50")

you can also use different conditions as you wish, for example, sum only those sales figures whose orders are over 70, whose orders are between 50 and 65, less than 50, or whatever you can think of.