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.

COUNTIFS function counting specific records

Follow us on

Facebook  Twitter  You Tube 

Other Statistical Functions

Excel 2010 Superhero Course