How to dynamically generate the Formula

[simi]

Hi,

I need to apply the following formula in a single cell

=(C3*C3)+(D3*D3)+(E3*E3)...


Is there anyway to achieve this dynamically instead of manually tying the formula ?

[Fotis1991]

One simple way to do is this,

In C4 put this. =C3*C3. Drag across as mutch as you want. This will be a helper and hidden row.

Then use something like this: =SUM(C4:CH4)

[Pepe Le Mokko]

Also try the SUMSQ function. In your case

Please Login or Register  to view this content.

( adapt range as needed) or somewhat more general

Please Login or Register  to view this content.

[Fotis1991]

@ Pepe

SUMQ I see this function for first time! I NEVER heard about this. Excellent!

Which could be the problem that your second suggestion gives wrong result?

[kvsrinivasamurthy]

Use this in E4 and drag across

Please Login or Register  to view this content.

[simi]

Hi,

I am sorry there is a typo error in the formula. The correct formula as follows
=(C3*C7)+(D3*D7)+(E3*E7) ... +(Z3*Z7)

[Fotis1991]

post#3?....