description:
Count cells that match multiple criteria. |
syntax:
=COUNTIFS( criteria_range1, criteria1, [criteria_range2], [criteria2], … ) |
required arguments:
criteria_range1 | The first range to check. |
criteria1 | The criteria to use on criteria_range1. |
optional arguments:
[criteria_range2] | The second range to check. |
[criteria2] | The criteria to use on criteria_range2. |