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