Excel formula for Sum of Power , Need to Expand Cell by Cell-CodePudding

Thanks lot for all support...

I need to write one formula and Drag down to get the sum of the power 2.

=POWER(B2,2) POWER(B3,2) POWER(B4,2) POWER(B5,2)

I need to get the Sum of Power 2, For that need to write formula in cell C2 and Need to Drag till C5 .

Because I have more than 100 cell to drag this same Formula

Because if I type Manually it very critical to add one by one.

And drag that down.

Or if you have Office 365 Excel you can put:

=SCAN(0,B2:B5,LAMBDA(a,b,a b^2))

In C2 and it will spill.

CodePudding user response：

Try this in Column E for example:

for the first cell(E2) = POWER(B2,2)
for the second cell(E3) = POWER(B3,2) E2
cell E4 = POWER(B4,2) E3

and so on...