next up previous contents index
Next: CTERM Up: A. Function Reference Previous: CSTDS   Contents   Index


CSUM

Syntax: CSUM(argumentlist, C)

argumentlist = any combination of cells or ranges
C = a constraint expression

CSUM returns the sum of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not counted.

Examples:

CSUM(L1..L3, #$<$5) = 1.32, where L1 = 1.32, L2 = 5.45, and L3 = 8.32

CSUM(C5..C10, #$>$=D1/D10) = 150, where C1..C10 are 10, 20, 30, 40, 50, and D1 = 100 and D10 = 10

Excel function: N/A


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