next up previous contents index
Next: CEIL Up: A Function Reference Previous: CAVG

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


next up previous contents index
Next: CEIL Up: A Function Reference Previous: CAVG

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999