next up previous contents index
Next: CEIL, CEILING, XLCEILING Up: A. Function Reference Previous: CAVG   Contents   Index


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


next up previous contents index
Next: CEIL, CEILING, XLCEILING Up: A. Function Reference Previous: CAVG   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003