SUMIFS Countifs, sumifs, and Averageifs are some of the most used formulas in Excel. SUMIFS() allows you to sum the values within a specified range conditionally if criteria in other ranges are met. SUMIFS Formula =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2],…) Sumifs will sum the values in the range only if Continue Reading