title: Countifs between two values and input answer in a new sheet with vba
body: <p>I have Column A with more than 100 Product IDs, Column B with prices. I want to countif Column B is less than 80 and greater than 20, then put the answer into a new sheet. I can't get the counties right. Thank you for helping out!</p>
  
  <pre><code>Sub MyCount()
  Dim MySum as variant
  MySum = Application.WorksheetFunction.Countifs(B:B,"&gt;25", B:B, "&lt;80")
  Worksheets.Add.Range("A1").Value = MySum
  End Sub
  </code></pre>