Formula to Sum Data for Specific Month in 2024, Not Entire Year

System

This discussion was created from comments split from: Return sum of one column if today's date is between A and B, etc.

kmorsesmartsheet

Hello,

I am trying to implement a look back to December 2024 figures - formula below totals 2024 entire year. I know I'm overlooking where to insert the month, nothing seems to be working as I play around with this. Any suggestions?

Exiting Formula for total 2024 data:

=SUMIFS({F-10.1.1-02 Quality Summary Nonconformity  Range 2}, {Quality Summary Range 1}, [Look Up Fields]@row, {Quality Summary Range 5}, ISDATE(@cell ), {Quality Summary Range 5}, YEAR(@cell ) = YEAR(TODAY() - DAY(TODAY()) - 1) - 1)@cell

Paul Newcome

To specifically state 12/2024, you would use something like this:

=SUMIFS({F-10.1.1-02 Quality Summary Nonconformity  Range 2}, {Quality Summary Range 1}, [Look Up Fields]@row, {Quality Summary Range 5}, AND(IEFRROR(MONTH(@cell), 0) = 12, IFERROR(YEAR(@cell), 0) = 2024))

Genevieve P.

@kmorsesmartsheet

Just sending you an @mention to make sure you saw Paul's response above 🙂