Microsoft® Excel® 2010 Formulas & Functions Inside Out

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. ...