CountIFS for multiple months within a year.

Kris V. Le

Hello,

I'm trying to count the recurrence of an event associated with specifically Q1 of a year. So basically count [Column A] IF Date Column] Month is 1-2 in the year 2021.

Any takers?

Paul Newcome

Try somethign like this...

=COUNTIFS([Column A]:[Column A], @cell = "Event text", [Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) >= 1, IFERROR(MONTH(@cell), 0) <= 4, IFERROR(YEAR(@cell), 0) = 2021))

Paul Newcome

Try somethign like this...

=COUNTIFS([Column A]:[Column A], @cell = "Event text", [Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) >= 1, IFERROR(MONTH(@cell), 0) <= 4, IFERROR(YEAR(@cell), 0) = 2021))

Kris V. Le

https://community.smartsheet.com/discussion/comment/307934#Comment_307934

Thank you sir! This was the fix I needed.

Paul Newcome

Happy to help. 👍️