SUMIFS Function

The SUMIFS function calculates and finds the total of numbers, which match the multiple criteria given.

Formula:


=SUMIFS(Sum range, Criteria range1, Criteria1, Criteria range2, Criteria2)
"Sum range" is the range to be added if the cells match the given criteria; "Criteria range1, criteria_range2,..(can be up to 127)" are the ranges in which the criteria is evaluated; "Criteria1, criteria2,...(can be up to 127)" are the conditions that define which cells are to be added.

Video Tutorial:


Let us find the sum of the given set of numbers based on condition, using the SUMIFS function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question