VBA Formula Ask

[UBSmokie]

Hello - I know this is possible, and potentially easy. I just don't know how to do it. What I'm looking for is code that can perform the following formula in cell G23:

=((B7/B23)*G7)+((B8/B23)*G8)+((B9/B23)*G9)+((B10/B23)*G10)+((B11/B23)*G11)+((B12/B23)*G12)+((B13/B23)*G13)+((B14/B23)*G14)+((B15/B23)*G15)+((B16/B23)*G16)+((B17/B23)*G17)+((B18/B23)*G18)+((B19/B23)*G19)+((B20/B23)*G20)

I need to continually add to that formula as each double set of parentheses represents a month of data. My problem is that I'm going to hit the character limit preventing me from adding on to the above formula soon. Can anyone help?? Thanks in advance for taking a look!

[Paul]

Hi UBSmokie,

Does this array formula work for you? You must press CTRL+SHIFT+ENTER after typing it, not just ENTER.

=SUM((B7:B20/$B$23)*(G7:G20))

[UBSmokie]

It does - thank you!