Excel: y = sum( x1^2+x2^2+ ... +xn^2) in one cell?

Question

How to I sum the squares of many cells: Without having to make an extra column of squares .. in excel?

Can you make your own function in Excel?

it is actaully: y = sum( (a-x1)^2+(a-x2)^2+ ... +(a-xn)^2)

I need the sum of the squares

Answer 1

The SUM family functions are here
SUM
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2

Type any of those in the formula bar after the equal sign, the press the fx symbol and read the help

If none of them helped you, then I guess you will need that additional column to add, or do it in macro

Enjoy my profile, I am the VBAXLMan

Answer 2

Sum Of X 2

Answer 3

Sum Of Squares In Excel

Answer 4

Hi

Yes you can write your own functions in excel. You would ned to write some vba code to loop through the values of x(n) and multiply them by themselves whilst adding to a running total.

Its been a while since I did any vba in excel otherwise I would write some code to help you but I hope this has given you a starting point.

Answer 5

There is a command in functions of excel: "Sum Square"
Search for "sum square", "ssquare" or "ss"

Answer 6

please... before everything that video replaced into uploaded in mid 2007. on a similar time as I relish that Obama is in some techniques NAFTA friendly, have confidence me as quickly as I say that each and each American baby-kisser is conscious that it can be a actual impossiblity to connect the economies of the U.S. and Mexico i ought to pass on correct to the economic and political changes and how stuff like this video is trash, yet I merely don't have the ability. and people say Obama is into concern-mongering....

Answer 7

To sum the squares of A1 through A30, use:

=SUMSQ(A1:A30)

Answer 8

=sum(the top square:the bottom square)

example:
=sum(a4:a9)