SUMSQ()

Syntax. SUMSQ(number1,number2,...)

Definition. This function adds squared arguments.

Arguments

• number1 (required) and number2 (optional) Up to 255 arguments (30 in Excel 2003 and earlier versions) to add. You can also use an array with a single row or column or a reference to an array instead of arguments separated by commas.

Background. The SUMSQ() function calculates the square numbers of the given arguments and adds those numbers. The formula is:

Σ(a², b², c², d² ...)

More examples for this function are:

• =SUMSQ(2,3,4) returns 29 (4+9+16).

• =SUMSQ(5,6) returns 61 (25+36).

• =SUMSQ(12,3) returns 153 (144+9).

Sample Files

Use the PRODUCT_SUM worksheet in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.