Sumif with VBA

[Akbarov]

Hey Dear community,

i use this formula =SUM(SUMIF(D:D,A2:A10,E:E)) to find markets total income

D:D whole market names , A2 to A10 name of markets which i need to calculate. and E:E is income from markets

But data is very huge and array formula wont work.

Can anyone help me to do it with VBA code?

 

[Akbarov]

i found 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 use that?

 

[Akbarov]

any kind of help please?

 

[Fluff]

How about

   Cells(1, "L").Value = Evaluate("=SUM(SUMIF(D5:D314055,A2:A35,E5:E314055))")