HELP! How do I modify my formula to separate months and years?

I am separating "Total Monthly Sales," but I need to separate the years as well. For example, our projects were sold in 2021, but carried over into 2022. I need to be able to separate 2022 and 2021.

Here is my formula:

=SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!