CCOUNT

**Syntax:** **CCOUNT( argumentlist, C)**

*argumentlist* = any combination of cells or ranges

*C* = a constraint expression

**CCOUNT** returns a count of its non-blank arguments which
satisfy the constraint *C*. Cells containing strings are
counted.

**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
range C4..C100 whose value is greater than the contents
of the cell immediately above

**Excel function:** *N/A*

Grey Trout Software

02 March 2003