As you all know, Microsoft Excel provides users with a lot of functions to serve the calculation work, saving us a lot of time and significantly improving work efficiency.
Among the calculation functions, the SUM function is the most used function. In addition, we also have other “SUM family” functions such as SumIF, SumSQ, etc. and today, we will learn about the SUMSQ function – a function that supports the sum of squares of many numbers.
For example, I have a table like the image below. Now I will calculate the sum of squares function in the column
Sum of Squares
Formula to calculate sum of squares in Excel:
= SUMSQ (number1, [number2], [number3]…)
With number1, number2… are the numbers to calculate the sum of squares.
Applying the example, we will now enter the following formula in the cell
From here, you can directly enter the position of the cell to be calculated, or click with the mouse to enter the value
Next, you enter a comma (or semicolon – depending on the device) => and then select the value
number2. Finally close the brackets and press
Enter to display the sum of squares of
Number 1 and
You might like: Instructions to convert dots into commas in Excel
Here is the complete recipe.
To apply the formula to other cells, select the formula cell => then find the small square as shown below.
Click and hold that square => Fill it down to the last cell to automatically sum the squares of the remaining cells. This is how to copy formulas in Excel that everyone who works with Excel must know.
In addition to using the above formula, we can calculate the sum of squares using the SUM formula. Or to put it bluntly, it’s manual @@
You use the following formula:
Or like this to calculate the sum of a specific number:
==//end of further reading/==
Yes, that’s it, I’ve finished the tutorial for you how to calculate sum of squares in Excel, as well as how to use the sum of squares function in Excel. See you in the next posts.
CTV: Nguyen Hong Khanh – Blogchiasekienthuc.com
Note: Was this article helpful to you? Don’t forget to rate the article, like and share it with your friends and family!