CSUM(<List>, C)

 

Description

This function returns the sum of its arguments that satisfy the constraint C.  Blank cells and cells containing strings are ignored.

 

Parameters

 

<List>

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 = 10, 20, 30, 40, 50; D1 = 100, and D10 = 10.