COUNTIFS per month

I have the formula below, and need to count items per month

=COUNTIFS({CCS Scheduling sales person}, "RR", {CCS Scheduling Days over}, >1)

any ideas?

Thank you!


Answers

  • Hi @Lazar.A

    If I'm understanding you correctly, you have a Date column in your source sheet and you want to filter down your current formula to a specific month.

    If so, you can add in another {cross sheet reference} to that Date column, then check if the MONTH in each cell (@cell) of that column is equal to a specific number (ex. 1 for January).

    MONTH(@cell) = 1

    However, the MONTH function can sometimes error if there's a blank cell in the range, so we can wrap it in an IFERROR, like so:

    IFERROR(MONTH(@cell), 0) = 1


    Try something like this:

    =COUNTIFS({CCS Scheduling sales person}, "RR", {CCS Scheduling Days over}, >1, {Date Column}, IFERROR(MONTH(@cell), 0) = 1)


    Then you can swap out the = 1 to other months as needed.

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!