VBA sumif How can i indicate range?

Hey Dear community,

I use this code

Sub Macro1()
'
Set MyRg1 = Range("C5:C314055")
Set MyRg2 = Range("E5:E314055")
Cells(1, "L") = WorksheetFunction.SumIf(MyRg1, "MARKET", MyRg2)
'
End Sub

But instead of "MARKET" i need to use range from sheet2 A2:A35 how can i do that?