Application Guide

sum()
Catalog >
sum(Matrix1[, Start[, End]]) ⇒ matrix
Returns a row vector containing the sums
of all elements in the columns in Matrix1.
Start and End are optional. They specify a
range of rows.
Any void argument produces a void result.
Empty (void) elements in Matrix1 are
ignored. For more information on empty
elements, see page 236.
sumIf()
Catalog >
sumIf(List,Criteria[, SumList]) ⇒ value
Returns the accumulated sum of all
elements in List that meet the specified
Criteria. Optionally, you can specify an
alternate list, sumList, to supply the
elements to accumulate.
List can be an expression, list, or matrix.
SumList, if specified, must have the same
dimension(s) as List.
Criteria can be:
• A value, expression, or string. For
example, 34 accumulates only those
elements in List that simplify to the
value 34.
• A Boolean expression containing the
symbol ? as a placeholder for each
element. For example, ?<10 accumulates
only those elements in List that are less
than 10.
When a List element meets the Criteria,
the element is added to the accumulating
sum. If you include sumList, the
corresponding element from sumList is
added to the sum instead.
Within the Lists & Spreadsheet application,
you can use a range of cells in place of List
and sumList.
Alphabetical Listing 181