COUNTIFS returns the number of cells in a range on the base of multiple criteria in the parameter.
COUNTIFS( criteria range1, criteria1,.. )
Parameters Details
- criteria range1 : Frist range of cells that you want to count based on the criteria.
- criteria1 : Frist criteria used to determine which cells to count.
- … : Next criteria range and next criteria.
Returns
The COUNTIFS function returns a numeric value.
