Excel > Functions

COUNTIFS Function

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.

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Guides