next up previous contents index
Next: 4.4 String Functions Up: 4. Built-in Functions Previous: 4.2 Statistical Functions   Contents   Index


4.3 Conditional Statistical Functions

Conditional Statistical Functions operate much like statistical aggregation functions, except that the last argument is a constraint expression that SpreadScript evaluates for each cell in the argument list. Only cells that meet constraint criteria are included in the calculation. The constraint expression may be any SpreadScript expression that evaluates to a numeric result.

Conditional Statistical Functions return a numeric value.

For more information on constraint expressions, please see Chapter 3, Calculations.


next up previous contents index
Next: 4.4 String Functions Up: 4. Built-in Functions Previous: 4.2 Statistical Functions   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003