Excel > Excel 2003 Intermediate > More Functions

CountIf

The COUNTIF function counts the number of values in a range that meet specific criteria. For example it will return how many orders were placed by a specific company or after a specific date.

The syntax for COUNTIF is:

=COUNTIF(range, criteria)

Argument

Purpose

Range

The range of cells to evaluate.

Criteria

The condition that defines which cells are to be counted.

The example below demonstrates COUNTIF being used to return the number of exams that were passed.

CountIf function

Follow us on

Facebook  Twitter  You Tube