Sumproduct search result by year

[chunu]

Hi,
below formula sum by month , how can i check specific year record.
pick year from cell i2

lastRow = Worksheets("FUNDS").Cells(Rows.Count, "a").End(xlUp).Row
   lastRow = WorksheetFunction.Max(2, lastRow)
    With Sheets("SUMMARY").Range("c2:c13")
            .Formula = "=SUMPRODUCT(--(MONTH(FUNDS!$a$2:$a$" & lastRow & ")=$A2),FUNDS!$c$2:$c$" & lastRow & ")"
             .Value2 = .Value2
                End With

thanks

 

[Phuoc]

"=SUMPRODUCT((MONTH(FUNDS!$a$2:$a$" & lastRow & ")=$A2) * (YEAR(FUNDS!$a$2:$a$" & lastRow & ")=$I2),FUNDS!$c$2:$c$" & lastRow & ")"