Excel COUNTIFS function
Function COUNTIFS
Description Excel COUNTIFS function counts the value of those cells within a range which meets multiple criteria.
Syntax COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)
criteria_range1 This is the first range to evaluate.
criteria1 The criteria which to be used on criteria_range1.
criteria_range2 [optional] This is the second range to evaluate.
criteria2 [optional] The criteria which to be used on criteria_range2.
Click here to posts related to function COUNTIFS
Related Video Tutorials: