SUMIFS Question

Could you please provide guidance on the "SUMIFS" formula? I'm trying to calculate the following information:

  1. Sum the amount of a service type completed between a certain amount of time based on the price.
  2. Goal to add the amount of Nutrition Facts Revision service types completed between April 1 and April 30th based on the Invoice date. 
  3. Columns that using Service Type (Drop Down Text), Invoice Date (Calendar Dates), and Price (Dollars) 
  4. I tried =SUMIFS(Price:Price, [Invoice Date]:[Invoice Date], >=4 / 1 / 19, [Invoice Date]:[Invoice Date] <= 4 / 30 / 19, [Service Type]:[Service Type] = "Nutrition Facts Revision") but it computes to #Invalid Operation.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!