Investment Studio > Expressions > Functions > Math & Trig > SUM

float sum(float data [, ...])

Returns the sum of all arguments which are (or can be converted to) real numbers.

The input data may include arrays, in which case each array element will be treated as a separate argument.

Example

=sum(5, 6, {{7, "8"}, {TRUE, "This is not a number!"}})

equals 27: "8" is converted to 8; TRUE is converted to 1; "This is not a number!" doesn't convert, so it's ignored (note that this is not an error condition).

See also average, count, counta, countif, product, sumif, sumproduct, sumsq.