SUMIFS examples =SUMIFS( A1:A10, B1:B10, “>1000”, C1:C10, “East” ) The above example says that sum the cells in range A1:A10 where its corresponding B1:B10 cells is greater than 1000 and at the same time if the corresponding C1:C10 is “East” It is similar to the SUMIF function but with one exception that SUMIF can only check one criteria but SUMIFS can do multiple criteria checking Ĭriteria Operator We can use the operators in the criteria field, these operators are called the relational operators and they are Operator Description > Greater Than Not Equals to >= Greater Than & Equal to =SUMIFS( sum_range, criteria_range1, criteria1, ….) This is the range which will contain the numbers which you want the sum for This is the range which contains the range of cells in which you want to check the criteria1 This is the criteria which you want to search into the criteria_range1, this parameter may be enclosed in “ inverted commas or may be a cell reference This is the range which will contain the range of cell in which you want to check the criteria 2, this is similar to criteria_range1 with one exception that it will look for criteria2 This is the criteria 2 which you want to search into the criteria_range2 this parameter may be enclosed in “ inverted commas or may be a cell reference Introduction SUMIFS Function is new induction in the Microsoft Excel’s Function family This is a wonderful function which can sum a range of cells depending on the criteria specified by the user.