SUMIFS formula


Can someone help me with a formula to track how many packs have been taken/used each month of each year? I have MONTH and YEAR columns from a date entered.

So far no luck with =SUMIFS(Number taken:Number taken, MONTH "1", YEAR "2022")


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @peter65516

    The syntax needs some adjusting. The syntax is SUMIFS(range to be summed, range1, criteria1, criteria2, etc). The formula is missing the commas in between ranges and criteria and the criteria ranges need to identified as the entire column - don't forget column names that include spaces, numbers or special characters require square brackets. Also, Numbers should not be enclosed in quotes. This confuses smartsheet as to whether the enclosed numbers should behave as text or as numbers. It is seldom any number should ever be enclosed.

    =SUMIFS([Number taken]:[Number taken], Month:Month, 1, Year:Year, 2022)

    Does this work for you?


  • peter65516
    peter65516 ✭✭✭✭

    Thank you Kelly, I have such trouble with formulas but I learnt some very handy things from your answer and you solved my immediate problem. Thanks again!

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    I'm glad it helped! Thanks for coming to the community


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!