Other Statistical Functions

Excel > Excel 2007 Intermediate > More Advanced 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 adding school grades passed

Follow us on

Facebook  Twitter  You Tube