Use variable to define cell in sumif statement

[sleibo]

I am trying to use sumif statement with variable cell locations. In this snippet, sumif works as it should when R1C1 or absolute cell locations are used, but I can not get it to work using variable for cell location as in last line. Assist?

'
Dim Nmbr As Long
Nmbr = 32
ActiveCell.FormulaR1C1 = _
"=SUMIF(R[6]C[-7]:R[28]C[-7],""RNT Rent"",R[6]C[-6]:R[28]C[-6])"
Selection.ClearContents
ActiveCell.Formula = "=sumif(E10:e32,""RNT Rent"",F10:f32)"
Selection.ClearContents
ActiveCell.Formula = "=sumif(""E10:e""&Nmbr,""RNT Rent"",F10:f32)"
End Sub

 

[Anthony47]

Beware where strings starts and ends; try

ActiveCell.Formula = "=sumif(E10:e" & Nmbr & ",""RNT Rent"",F10:" & Nmbr & ")"

 

[sleibo]

Thanks, Anthony47. Once I put in the extra "F" (after F10 it worked!

 

[Anthony47]

Once I put in the extra "F" (after F10: ) it worked!

Correct, it had to be ...,F10:F" & Nmbr...
Thank you for the feedback