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