 Formula Engine Reference Guide |
|
Back to Class Index
CSUM(argumentlist, C)
Returns the sum of its arguments which satisfy the constraint C. Blank cells and cells containing strings are not counted.
Parameters
argumentlist
Any combination of cells or ranges
C
A constraint expression
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