SumIFS with YTD and Month

Ivan Perez
Ivan Perez ✭✭✭
in Formulas and Functions

Hello, I am trying to summarize the total of cures by branch, by year and month below is the formula I am trying to use.

SUMIFS({Cure Amount}, {Date}, IFERROR(YEAR(@cell), 0) = 2021, IFERROR(MONTH(@cell), 0) = 1, {Branch}, "Triad (800)")

Your help is greatly appreciate.

Thank you

· Share on FacebookShare on Twitter

Best Answers

  • Kelly Moore
    Kelly Moore Community Champion
    Answer ✓

    Hi @Ivan Perez

    The formula is missing a range. Each term has to be paired with a range, even if the range is same as previous range.

    =SUMIFS({Cure Amount}, {Date}, IFERROR(YEAR(@cell), 0) = 2021, {Date}, IFERROR(MONTH(@cell), 0) = 1, {Branch}, "Triad (800)")

    cheers,

    Kelly

    · Share on FacebookShare on Twitter
  • Kelly Moore
    Kelly Moore Community Champion
    Answer ✓

    Alternatively

    SUMIFS({Cure Amount}, {Date}, AND(IFERROR(YEAR(@cell), 0) = 2021, IFERROR(MONTH(@cell), 0) = 1), {Branch}, "Triad (800)")

    · Share on FacebookShare on Twitter

Answers

  • Kelly Moore
    Kelly Moore Community Champion
    Answer ✓

    Hi @Ivan Perez

    The formula is missing a range. Each term has to be paired with a range, even if the range is same as previous range.

    =SUMIFS({Cure Amount}, {Date}, IFERROR(YEAR(@cell), 0) = 2021, {Date}, IFERROR(MONTH(@cell), 0) = 1, {Branch}, "Triad (800)")

    cheers,

    Kelly

    · Share on FacebookShare on Twitter
  • Kelly Moore
    Kelly Moore Community Champion
    Answer ✓

    Alternatively

    SUMIFS({Cure Amount}, {Date}, AND(IFERROR(YEAR(@cell), 0) = 2021, IFERROR(MONTH(@cell), 0) = 1), {Branch}, "Triad (800)")

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!