Complex average formula.

[little_birdie]

Hi Guys,
I need help with a calculation of complex average formula. I seek macro code of this so that I can incorporate it in my VB.NET application.

If you open the attachment with this post, you'll find the excel report I am trying to generate.

The number of columns vary, but the number of rows is constant.

Lets assume, max_col is the number of columns and max_row is the number of rows per report.
Then, I need the following logic as VB macro.

for row = 6
F6 = (G6*G4) + (H6*H4) + (I6*I4)+...+ ("max_col:6" * "max_col:4") / (G4+H4+I4... "max_col:4")

Any Excel pro out there who can help me ?

Thanks,
Little_Birdie

[rylo]

Hi

Here's one way

Please Login or Register  to view this content.

rylo

[little_birdie]

Rylo,
Thanks for the answer, works just as needed.