COUNTIFS per month

Lazar.A

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!

Genevieve P.

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