Excel VBA Countifs formula with range of lastrow

[bobbyexcel]

Can someone please help me on the below formula ..

Here I'm writing 3 different formulas which gives the same result.. but not sure how to write using vba.

Formula 1: In Col L : =COUNTIFS($A$2:$A$18,A2,$C$2:$C$18,C2,$I$2:$I$18,">""",$K$2:$K$18,">"&K2) + 1
Formula 2: In Col M : this formula is from macro recorder..

Dim Lastrow As Long
Lastrow = Range("L" & Rows.Count).End(xlUp).Row
Range("M2:M" & Lastrow).Formula = "=COUNTIFS(R2C1:R12C1,RC[-12],R2C3:R12C3,RC[-10],R2C9:R12C9,"">"""""",R2C11:R12C11,"">""&RC[-2]) + 1"
[B][U]

Formula 3: In Col L : Now I want to customize with lastrow which is not giving proper results.. Need help on this..

[/U][/B]
Dim Lastrow As Long
Lastrow = Range("L" & Rows.Count).End(xlUp).Row

Range("M2:M" & Lastrow).Formula = Application.WorksheetFunction.CountIfs( _
 Range("$A$2:$A$" & Lastrow), A2, _
 Range("$C$2:$C$" & Lastrow), C2, _
 Range("$I$2:$I$" & Lastrow), ">""", _
 Range("$K$2:$K$" & Lastrow), ">" & K2) + 1

 

[bobbyexcel]

Nevermind .. I figured it out..

With RANGE("M2:M" & Lastrow)
.FormulaR1C1 = "=COUNTIFS(R2C1:R" & Lastrow & "C1,RC[-12],R2C3:R" & Lastrow & "C3,RC[-10],R2C9:R" & Lastrow & "C9,"">"""""",R2C11:R" & Lastrow & "C11,"">""&RC[-2]) + 1"
.Value = .Value
.NumberFormat = "0"

End With