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, …)
|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.