SUMIFS in VBA

[ARUNCHENNAI]

Can some one explain, point the error & provide correct code.
The below code is getting the result

.Range("P2:p" & lr).Formula = "=SUMIFS(L:L,I:I,O2,M:M,$P$1)"

But the below code is just summing up only the value of O2

.Range("P2:P" & lr) = WorksheetFunction.SumIfs(.Range("L:L"), .Range("I:I"), .Range(O2), .Range("L:L"), "=RAxle")

Regards
Arun

 

[BrianJN1]

.Range("P2:P" & lr) = WorksheetFunction.SumIfs(.Range("L:L"), .Range("I:I"), .[COLOR=#ff0000]Range(O2)[/COLOR], .Range("L:L"), "=RAxle")

Shouldn't the O2 be in quotes, ie, "O2" ?

 

[ARUNCHENNAI]

Shouldn't the O2 be in quotes, ie, "O2" ?

Thank you BrainJN1.
I tried, but not working.

 

[BrianJN1]

That's not good, sorry. I saw something that looked out of placed.
Could you take a look at the formula:

.Range("P2" & lr).Formula = "=SUMIFS(L:L,I:I,O2,M:M,$P$1)"

In that previous instance you had range(O2) in the second formula. As I look at the above formula, your first, I see$P$1. Should "O2", being an absolute point of reference be written as $O$2? That's my last chance to troubleshoot.

 

[ARUNCHENNAI]

Thank you BrainJN1.
I got it right by adding variables in place of "O2".

Arun

 

[BrianJN1]

Glad to hear that you have a solution.