Totaling cost by month


I am tracking medical case cost, i am trying to auto calculate the cost for the month using a date range. Formula is giving incorrect argument error.

=SUMIFS({date}, AND(@cell <= DATE(2019, 5, 1), @cell >= DATE(2019, 5, 31), {cost}))

someone help tell me where i am going wrong?


  • Kyle Black
    Kyle Black ✭✭✭✭✭

    =SUMIFS({cost}, {date}, <=DATE(2019, 5, 1), {date}, >=DATE(2019, 5, 31))

    I got this to equal 0, which is not right, but had found another formula to try

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Kyle Black

    You found the issue I was going to point out - with a SUMIFS (plural), you put the range you want to SUM at the start of the formula, versus the end.

    A 0 would indicate that the formula is structured correctly, but it either can't find data for that date range or that your {cost} column is being read as text instead of values to SUM. If you're still seeing incorrect results, could you post a screen capture of the referenced sheet (but please block out sensitive data!)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!