Count for the months

Marilen.Navarro103391

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.

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.

Jared L.

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.