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

Matt Gleaves

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])

Matt Gleaves

Here is my updated formula. I feel like I am close but obviously something is not working correctly.

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

Genevieve P.

Hi @Matt Gleaves

I've answered you on this other thread:

https://community.smartsheet.com/discussion/comment/347916#Comment_347916

Let me know if you still have questions and I'd be happy to help further!

Cheers,

Genevieve