The SUMSQ function returns the sum of the squares of the arguments.

SUMSQ takes 1 required argument and 254 optional arguments:

Syntax: SUMSQ(number1, [number2], ... )

#1)
Using the SUMSQ function:
#2)
The arguments for the SUMSQ function are:
Argument Required? Description
number1, number2, ... Required number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want the sum of the squares. You can also use a single array or a reference to an array instead of arguments separated by commas.
#3)
A few things:
The arguments should be either numbers or names, arrays, or references that contain numbers.
Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted.
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
Arguments that are error values or text that cannot be translated into numbers cause errors.

Summary

The SUMSQ function returns the sum of the squares of the arguments.
comments powered by Disqus