• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » how to calculate sum of squares in Excel

how to calculate sum of squares in Excel

January 26, 2022 by mechanicaleng blog Leave a Comment

Today, mechnicalengblog,com will introduce to you sum of squares function in Excel and how to use it. As you know, excel have many function, and you will have many ways to calculate sum of squares  in excel, but what is the best?

How to calculate sum of squares in Excel?

The formula to calculate sum of squares in Excel:

= SUMSQ(number1, [number2], [number3], [number4] …)
With number1, number2… are the numbers which you want the sum of the squares.

To understand easily, i have table below. Now we will calculate the sum of squares.

How to calculate sum of squares in Excel 1
Applying this formula , we will now enter the formula in the cell D2

How to calculate sum of squares in Excel 2
Use your mouse and select A2 cell, or you can typing A2.

How to calculate sum of squares in Excel 3
next, you enter a comma (or semicolon – depending on the device) and use your mouse to select B2. You can do the same work to select C2.

How to calculate sum of squares in Excel 4

Finally close the brackets and press Enter. The result of the sum will show at D2.

How to calculate sum of squares in Excel 4
To apply the formula to other cells, select the formula cell and move your mouse to the end of the cell, until your mouse have back plus shape.

How to calculate sum of squares in Excel 6

Fill it down to the last cell to automatically sum the squares of the remaining cells. The result of all cells will display.

How to calculate sum of squares in Excel 7

If you don’t use SUMSQ function, you also calculate the sum of squares manually.
This is formula that you can use

=SUM((A2)^2, (B2)^2,(BC)^2)

For example above, you can do same this picture below.

How to calculate sum of squares in Excel 8

 

CONCLUSION

Yes, that is all, mechanicalengblog.com has finished the guide for how to calculate sum of squares in Excel? We already know how to use SUMSQ function in excel. I hope it can help you.

Thank you and see you in the next post.

Related posts:

How to count blank cells in excelHow to count and color blank cells in excel break line in excel by format cells4 ways to break line in excel Random number from fixed set of optionsCreate random number in excel word formula boxAdd and use word formula in table word 2016

Filed Under: excel tips Tagged With: excel tutorial

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in