Date and SUMIF or SUMIFS formula

I am needing help with the following formula. This following formula sums up by the month but I need it to sum by month AND year. For example, add up all January 2020 and then February 2020...etc. Any help is appreciated.

=SUMIF({Production Credits_2020 Range 12}, MONTH(@cell) = 1, {Production Credits_2020 Range 16})

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!