Why isn't my COUNTIF formula updating?
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the data from is a dropdown selection - which I have never had issues with before now. When I plug in the formula, it registers as zero even when there are counts for the status (see image below). This is the formula I am using: =COUNTIF([Row Title]:[Row Title], "status option")
Help Article Resources
Check out the Formula Handbook template!