Excel – How to obtain sum of square of all cells in a column in Excel

microsoft excel

In excel, my data is populated from Cell B1 to B10 in Excel. I want to obtain the sum of the squares from B1 to B10.

I could use a simple function POW(B1,2)+POW(B2,2)......+POW(B10,2). But this is too cumbersome to write and error prone.

Is there a shortcut function that is similar to SUM(B1:B10)?

Best Answer

Use SUMSQ

=SUMSQ(B1:B10)
Related Question