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?

Answers

  • 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!)

    Thanks,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!