Count for the months


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))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!