Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

COUNTIF

Description: Counts the number of cells within a specified range that meet the criteria you specify.

Syntax: COUNTIF(Range, Criteria)

Remarks:

Example:

COUNTIF(A2:A5, "apples") = 2 [number of cells with apples]

COUNTIF(B2:B5, ">55") = 2 [number of cells with a value greater than 55]

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.