Keithley 4200A-SCS - SUM Calc Worksheet Function; SUMSQ Calc Worksheet Function

Section
6: Clarius Model 4200A-SCS Parameter Analyzer Referenc
e 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
AVERAGE (on page 6-277)
PRODUCT (on page 6-290)
SUMSQ (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
SUM (on page 6-294)