Help combining calculations containing absolute references

[Briski]

Hello there,
I have the following formula:

=SQRT(SUM($N$2:$N2)/SUM($G$2:$G2))

Column 'N' refers to a simple calculation: = B2*B2*G2

Can anyone supply a simple method of combining the calculation in column 'N' directly into the original formula?

Thanks in advance,
B.

 

[FormR]

Hi, welcome to the board!

You can try:

=SQRT(SUMPRODUCT($B$2:$B2,$B$2:$B2,$G$2:$G2)/SUM($G$2:$G2))

 

[sparky2205]

=sqrt(sum(b2*b2*g2)/g2)

 

[Briski]

Hi,
Thanks! That worked perfectly!
B.

 

[Briski]

Thanks!