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: