CCOUNT(<List>, C)

 

Description

This function returns a count of its non-blank arguments that satisfy the constraint C.  Cells containing strings are counted.

 

Parameters

 

<List>

Any combination of cells or ranges.

 

C

A constraint expression.

 

Examples

 

CCOUNT(T2:T6, #==W2) = 1

Where T2:T6 are 4, 7, 2, 8, 0, and W2 = 7.

 

CCOUNT(E1:E3, #=0) = 3

Where E1 = 1, E2 = 5, and E3 = 0.

 

CCOUNT(C4:C100, ##0, -1) = 68

Counts those cells in the range C4:C100 with values greater than the contents of the cell immediately above.