VBA sumproduct with dynamic range

[chunu]

Hi,

can some one help me to make SUMPRODUCT formula with dynamic range, as below.

Actual formula

With Range("c2:c" & LastRow)        .Formula = "=SUMPRODUCT(--(MONTH(sales!$B$2:$B$300)=$A2),sales!$K$2:$K$300)"
        .Value2 = .Value2
   End With

Required like this

With Range("c2:c" & LastRow)    .Formula = "=SUMPRODUCT(--(month(sales![COLOR=#ff0000][B]b2:b[/B][/COLOR] & lastrow  =$A2),(sales![B][COLOR=#ff0000]k2:k[/COLOR][/B] & LastRow )"
   End With

Thanks

 

[Fluff]

Try

.Formula = "=SUMPRODUCT(--(MONTH(sales!$B$2:$B$" & Lastrow & ")=$A2),sales!$K$2:$K$" & Lastrow & ")"

 

[chunu]

Thanks a lot

 

[Fluff]

You're welcome