Fresh Excel Tips

In this example we will be illustrating how to use the SUMSQ Function. Excel provides the SUMSQ function to sum the squares of the arguments. Here is the syntax that is used for the SUMSQ Function:
SUMSQ(number1, number2, …)
number1, number2, …: From 1 to 30 arguments that will have their squares summed up. Instead of values, you can use a single array or a reference to an array separated by commas.

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.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. Using the SUM function to Sum a Range of Values in Excel
2. How to Use the SUBTOTAL function to sum a filtered list in Excel
3. How to use the GCD function to determine the greatest common divisor
4. How to Use the LCM function to determine the least common multiple
5. Use the POWER function to calculate the square and cube roots