The Excel COUNTIFS function is similar to the COUNTIF function. It counts all the cells from a given range that meets multiple criteria.
The syntax for the COUNTIFS function is:
=COUNTIFS(criteria_range1, criteria1, …)
| Argument | Purpose |
|---|---|
| Criteria_range | The range of cells you want to look for items to count |
| Criteria | The criteria to determine whether the cell is counted or not |
The example below shows the COUNTIFS function being used to count the number of subjects where the average coursework and exam grades are 75% or higher.
