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.