title: sumif function vba faster
body: <p>I am using sumifs function in my vba codes but I noticed the speed has been slow, takes minutes since I have 10k-20k records each week. </p>
  
  <p>Here is the portion of codes that reflect the sumif funciton, so the codes work but I am looking for ways that can help it to run faster. </p>
  
  <pre><code>For i = 2 To LR10
  MOB_T.Cells(i, 13).Value = Application.WorksheetFunction.SumIfs(Rng370, Rng380, MOB_T.Cells(i, 12).Value, Rng390, Selection.Cells(6, 2).Value)
  Next i
  </code></pre>