Count for the months

Question

Hi,

Hope you could help me.

I want to count all status  of "Pending" for the remaining months, Oct, Nov, Dec 2021. I was able to generate only October. How to add Nov and Dec. Thanks.

=COUNTIFS({2021 Orders - Richard Range 1}, "Pending", {2021 Orders - Richard Range 1}, AND(IFERROR(MONTH(@cell), 0) = 10, IFERROR(YEAR(@cell), 0) = 2021))

Jared L. · Accepted Answer

I would recommend trying ">" in front of "= 10". So it would look like this "AND(IFERROR(MONTH(@cell), 0) => 10" that logic should include Oct, Nov, and Dec.