In excel, my data is populated from Cell
B10 in Excel. I want to obtain the sum of the squares from
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