title: VBA - SumIf with multiple criteria
body: <p>I'm having trouble figuring out how to set multiple criteria for a SumIf statement in VBA. This is what I'm using right now with only one criterion to set the value of a variable called Count_1.</p>
  
  <pre><code>Count_1 = Application.SumIf(Range("K84:K" &amp; LastRow), "B*", Range("G84:G" &amp; LastRow))
  </code></pre>
  
  <p>I need to add another criterion. In addition to the value in column K needing to begin with "B", the value in column L also needs to be 80.</p>
  
  <p>I know this can be done using SumIfs in an Excel formula, but I need it to be in VBA.</p>