Sum2
Calculates the numerical sum of the squared values in a list of values, ranges and/or lists.
Syntax
Sum2(param1, param2, ...)
param1 = first parameter to add (value, range, or list)
param2 = second parameter to add (value, range, or list)
... = nth parameter to add (value, range, or list)
Remarks
This function accepts an unlimited number of parameters.
Examples
Sum2(1, 2) = 5 (= 1 + 2*2)Sum2(A1:B3) = the sum of all of the squared numerical values in the A1:B3 range