SUMSQ

Definition: The SUMSQ function in Excel is used to find the sum of the squares of a range of data.

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

Situation: This formula is appropriate in situations where you need to find the sum of the squares of a range of data.

Example: If you have a range of data A1:A5 that contains the numbers 1, 2, 3, 4, and 5, you would use the formula =SUMSQ(A1:A5). This would return a value of 55, which is the sum of the squares of the data in the range.