title: Unable to get the Sumif property of the worksheetfunction Class
body: <p>Can anyone explain what I could do to fix this?</p>
  
  <p><img src="https://i.stack.imgur.com/PAsS2.jpg" alt="enter image description here"></p>
  
  <p>Here's the current code:</p>
  
  <pre><code>SumFinalUnusedSPQCement = WorksheetFunction.Sum(Application.WorksheetFunction.SumIf(Range("V4:V" &amp; lastRow + 3), "&gt;0", "B4:B" &amp; lastRow + 3))
  SumFinalUnusedSPQSand = WorksheetFunction.Sum(Application.WorksheetFunction.SumIf(Range("W4:W" &amp; lastRow + 3), "&gt;0", "C4:C" &amp; lastRow + 3))
  SumFinalUnusedSPQAggregate = WorksheetFunction.Sum(Application.WorksheetFunction.SumIf(Range("X4:X" &amp; lastRow + 3), "&gt;0", "D4:D" &amp; lastRow + 3))
  </code></pre>