Excel 2000 in a Nutshell

Name

SUMSQ

Synopsis

You can use SUMSQ to add the squares of multiple values. For example, if you have the values 4 and 5 the function would square each value and then add them together to get a result of 41 (16+25).

To Calculate

=SUMSQ(Number1, Number2, ...)

Number1, Number2, ...

You must specify between 1 and 30 different numeric arguments for this function. You can also specify arrays for each argument allowing you to have up to 30 different arrays of numbers, making the number or values basically limitless.

Example

Figure 14-25 shows how SUMSQ finds the sum of the squares for each array. Use the values calculated by the function to compare the results of the other functions in the example. Let’s say SUMX2MY2 returns the results of subtracting the square of one array from another array. Compare the value returned by that function to the value you would get by manually subtracting the results of returned by SUMSQ.