Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-294
4200A-901-01 Rev. C / February 2017
SUM Calc worksheet function
This command returns the sum of the supplied numbers.
Usage
SUM(
Value_list
)
Value_list
A list of as many as 30 numbers separated by commas
Details
The list can contain numbers, logical values, text representations of numbers, or a reference to a
range containing those values.
Error values or text that cannot be translated into numbers return errors.
If a range reference is included in the list, text, logical expression, and empty cells in the range are
ignored.
Example
=SUM(1000, 3500, 500)
=SUM(A10:D10)
Returns
5.0000E+3
.
Returns
6.0000E+3
if each cell in the range
contains
1500
.
Also see
(on page 6-277)
(on page 6-294)
SUMSQ Calc worksheet function
This command squares each of the supplied numbers and returns the sum of the squares.
Usage
SUMSQ(
Value_list
)
Value_list
A list of as many as 30 numbers separated by commas
Details
The list can contain numbers, logical values, text representations of numbers, or a reference to a
range containing those values.
Error values or text that cannot be translated into numbers return errors.
If a range reference is included in the list, text, logical expression, and empty cells in the range are
ignored.
Example
=SUMSQ(5, 9, 11)
Returns
227.0000E+0
.
Also see
(on page 6-294)
