COUNTIFS Function Explained
The COUNTIFS Function in Microsoft Excel is used to count the number of cells in a range that meet multiple criteria. It takes two or more range/criteria pairs as arguments and returns the count of cells that meet all the criteria.
COUNTIFS Function Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- criteria_range1: The range of cells that you want to apply the criteria against.
- criteria1: The criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted.
- criteria_range2: (Optional) The range of cells that you want to apply the criteria against.
- criteria2: (Optional) The criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted.