{"id":776,"date":"2019-04-19T12:33:29","date_gmt":"2019-04-19T09:33:29","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=776"},"modified":"2019-04-19T12:33:33","modified_gmt":"2019-04-19T09:33:33","slug":"the-sumsq-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-sumsq-function\/","title":{"rendered":"The SUMSQ Function"},"content":{"rendered":"\n

Returns the sum of the squares of the arguments. <\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

SUMSQ<\/strong>(number1, [number2], …<\/b><\/span><\/em>) <\/p>number1, number2, …<\/strong> : number1 is required, subsequent numbers are optional. Up to 255 arguments for which you want the sum of the squares. You can also use a single array or a reference to an array instead of arguments separated by commas.
<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n

Empty cells, logical values, text, or error values in the array or reference are ignored.<\/p>\n\n\n\n

Arguments that are error values or text that cannot be translated into numbers cause errors.<\/p>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the SUMSQ function:<\/strong><\/p>\n\n\n\n

In the cell B6 calculate the sum of squares of the cell range A1:B3 using a single function.<\/p>\n\n\n\n

\n