 Formula Engine Reference Guide |
|
Back to Class Index
CCOUNT(argumentlist, C)
This function returns a count of its non-blank arguments which satisfy the constraint C. Cells containing strings are counted.
Parameters
argumentlist
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 range C4..C100 whose value is greater than the contents of the cell immediately above