Microsoft Excel Functions & Formulas

Use the SUMSQ function to determine the

square sum

Excel provides the SUMSQ function to sum the squares of the

arguments.

SUMSQ(number1, number2, ...)

number1, number2, ...: From 1 to 30 arguments that will have

their squares summed up. Instead of values, you can use a sin-

gle array or a reference to an array separated by commas.

4

To determine the square sum:

1. In cells A2:A10 list valid numbers.

2. In cells B2:B10 list valid numbers.

3. Select cells C2:C10 and type the following formula:

=SUMSQ(A2,B2).

4. Press <Ctrl+Enter>.

Mathematical Functions 183

6

Figure 6-38