5/22/2020 Fabulous Examples of Excel Functions: The SUMSQ Function
Section: Excel Functions Tutorial: SUMSQ Function
How to Use the SUMSQ Function
This Keynote Support tutorial teaches the SUMSQ function of Microsoft Excel - a built-in function that calculates the sum
of the squares of a list of values. Squaring a number is multiplying that number by itself.
This tutorial also provides worksheet examples that show how the SUMSQ function can be used with various formulas and other Excel
functions.
○ Disclosure: This post may contain a liate links, meaning, at no additional cost to you, we may earn a small commission if you click through
and make a purchase. ○
The SUMSQ Function
https://www.keynotesupport.com/excel-functions/sumsq-function.shtml 1/5
5/22/2020 Fabulous Examples of Excel Functions: The SUMSQ Function
The SUMSQ function returns the sum of the squares of the arguments listed in the function. The syntax of the SUMSQ function is:
SUMSQ(number1, number2, ...)
Where:
► number1, number2, ... , are from 1 to 255 arguments for which Excel will calculate the sum of their squares. .
Note:
◘ The argument can be a number, cell reference, formula, or function that results in a number.
◘ Only numbers are counted. Text, error values, empty cells, and logical values are ignored.
◘ If an argument does not lead to a number, or results in an error value, the function itself may fail.
A KeynoteSupport.com Tutorial
Let's look at four examples of the SUMSQ function using cell references, cell ranges, math formulas, and other Excel functions.
Example #1: SUMSQ Function with Cell Addresses
In the spreadsheet below, cells C2 through C4 contain our data. The SUMSQ function resides in cell A2 and we've written it in cell
B2.
https://www.keynotesupport.com/excel-functions/sumsq-function.shtml 2/5
5/22/2020 Fabulous Examples of Excel Functions: The SUMSQ Function
The example, =SUMSQ(C2,C3), is simple. Here is how Excel processes the function:
• Square the value in cell C2: 2 x 2 = 4
• Square the value in cell C3: 3 x 3 = 9
• Add the squares together, 4 + 9 = 13, and return a value of 13.
Example #2: SUMSQ Function with Cell Range
The SUMSQ function was typed into cell A2 and described in cell B2. The data for our function resides in cells C2:C4.
In this example, =SUMSQ(C2:C4), Excel will sum the squares of a range of cells:
→ Square the value in cell C2: 2 x 2 = 4
→ Square the value in cell C3: 3 x 3 = 9
→ Square the value in cell C4: 4 x 4 = 16
→ Add the squares together, 4 + 9 + 16 = 29, and return a value of 29.
Example #3: SUMSQ Function with Math Formulas
In our sample worksheet, cells C2 through C4 contain our data. The function resides in cell A2, and the function description is
written in cell B2.
https://www.keynotesupport.com/excel-functions/sumsq-function.shtml 3/5
5/22/2020 Fabulous Examples of Excel Functions: The SUMSQ Function
In this example, =SUMSQ(C4/C2,C2+C3), rst Excel will make the calculations. Then nd the squares and add them together.
• C4/C2 equals 4 ÷ 2 = 2. Then square this value: 2 x 2 = 4
• Next, C2+C3 equals 2 + 3 = 5. It's square is 5 x 5 = 25
• Add the squares together, 4 + 25 = 29, and Excel returns a value of 29.
A KeynoteSupport.com Tutorial
Example #4: SUMSQ Function with IF Function
The function was typed into cell A2 and described in cell B2. The data for our function resides in cells C2:C4.
This example, =SUMSQ(IF(C4<9,4,0),C3), shows that we can use other functions inside the SUMSQ function.
→ The IF function asks if C4<9. Since that query is true, the IF function result is a 4 (value-if-true), and 4 x 4 = 16
→ The second argument of the SUMSQ function is the value of C3, which is 3. The square of 3 is 9.
→ The SUMSQ ads the squares: 16 + 9 = 25, and Excel returns a value of 25.
https://www.keynotesupport.com/excel-functions/sumsq-function.shtml 4/5
5/22/2020 Fabulous Examples of Excel Functions: The SUMSQ Function
We hope our tutorial on how to use the SUMSQ function of Excel has been useful. Cheers from Keynote Support!
↑ Return to the top
TOPICAL MENU PAGES
Accounting Basics
Excel Basics
Excel Functions
Money & Credit
Microsoft Windows
Other SW & HW
Web, Apps, Codes
Coming Soon
https://www.keynotesupport.com/excel-functions/sumsq-function.shtml 5/5
