Loop incrementing formula

[hgus393]

Hi all,

I am trying to loop a formula in VBA, but can't wrap my head around how to do it.

The formula on the starting row is:

=SUM(($C$5:$C$9=$X$4)*SUM($C$5:$C$9=$X$4))

How can I increment the following rows so that the following rows will be like this:

=SUM((Starting point from above ie C10 :increment by 5 ie c14 =$X$4)*SUM(Starting point from above ie C10 :increment by 5 ie c14=$X$4))

Next row

=SUM((Starting point from above ie C15 :increment by 5 ie c19 =$X$4)*SUM(Starting point from above ie C15 :increment by 5 ie c19=$X$4))

and so on

Cheers

Rob

 

[hgus393]

Awesome. The FormulaArray was exactly needed!

Right back at ya!