Related Topics:

Spreadsheet Math Functions

Formulas Tab and Insert Function

Data Entry Tips for Functions

Function Wizard

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-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link