Sumproduct in vba (formula array)

[Statsman]

Hello everyone,

I have a function that has a formula sumproduct and here it is:

Set RSheet = Worksheets("Rawdata")
Set RSheet = Worksheets("Rawdata")

RSheet_lastRow = RSheet.Cells(Rows.Count, "A").End(xlUp).Row
RSheet.Range("AJ2:AJ" & RSheet_lastRow).Formulaarray = "=SUMPRODUCT
((V2>=ProjectedStarts!$K$1:$K$45)*(V2<=ProjectedStarts!$L$1:$L$45),ProjectedStarts!$M$1:$M$45)"

The problem is that when the formula is sent to each cell V2 (bolded) does not change to V3, V4, V5.

Am I doing something wrong? Could you please find the error that I am making?

Thanks,

[protonLeah]

Please insert you code between the code tags to facilitate reading/copying.
Post all the code or, better yet, a workbook. We need to know how the variables are TYPED/DIM'ed

[DonkeyOte]

Ditto ProtonLeah re: tags...

re: prior to posting back be sure to check out .FormulaR1C1 in VBA Help ... you don't need to enter your Sumproduct formula as an Array given it isn't a CSE Array formula in this instance.

[JONvdHeyden]

I agree with Donkey, but here's one way of collecting the syntax.

Write the formula in the cell. Then on the menu toolbar go to Tools > Options > General (tab) and check R1C1 reference style.

Then return to your worksheet and copy the SUMPRODUCT formula and use that in your code instead. Should read something like:

Please Login or Register  to view this content.