sumsq function in VBA

[ankita.sethi]

Hi,

I am trying to calculate the sumsq throught VBA for some automation.
The formula to be entered is - =SUMSQ(K1025:K1358)/(COUNT(K1025:K1358)-COUNTIF(B1025:B1358,"0"))
Another thing is that the row numbers are variables, and not fixed in automation. Let's call them R1 and R2. So I need the range to be R1 to R2 in all the instances in the above formula.

Any help is appreciated.

 

[ankita.sethi]

The formula is -

=SUMSQ(K1025:K1358)/(COUNT(K1025:K1358)-COUNTIF(B1025:B1358,"0")) <TBODY></TBODY>