Calculate Entries by Month and Year

Hi everyone,

I am currently capturing the month and year an item is closed. Colum A shows the Month, column B shows the Year ([Jan] [2024]). Can someone tell me the formula that I can use to count the items that are closed in a particular month?

To calculate the entries closed in Jan I've tried using:

=COUNTIFS([Request Reporting Month]:[Request Reporting Year], AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024))

But the total comes out as zero. Which is wrong.

Thanks for the assist!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!