title: SUMIFs function within VBA not working correctly
body: <pre><code>Public Function GRIDSALES(rev_date As Date, grid_date As Date) As Variant
  
        Application.Volatile (True)
  
                 Set Final_Price = Sheets("KRONOS").Range("$H:$H")
                 Set Team = Sheets("KRONOS").Range("$DO:$DO")
                 Set First_PD = Sheets("KRONOS").Range("$Q:$Q")
  
                  GRIDSALES1 = Application.WorksheetFunction.SumIfs( _
                                Final_Price _
                                , Team, "&lt;&gt;9" _
                               , First_PD, "&gt;=" &amp; rev_date, First_PD, "&lt;=EoMonth(" &amp; grid_date &amp; ")")
  
         End Function
  </code></pre>
  
  <p>VBA code above complies without any error but does not generate an answer.   I am trying to create a UDF that’s sums the Final Price for all sales teams (excluding team 9) between two dates <code>rev_date</code> and <code>grid_date</code>.  What am I missing?</p>