Count multiple criteria in a row
I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column.
=COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of the Semi-Annual Update cells, but I can not figure out to get the total of all cells with Semi-Annual Update, In Progress, and Waiting on County. Below is a screenshot of my sheet:
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!