Forum Discussion
COUNTIF Equation Issues
I'm having trouble with a COUNTIF formula which is trying to determine the percentage of requirements met based on the following: There are 5 test requirements, ranging from K5:O5. Options for ea...
Is it possible for you to post a copy of the actual file (or, if the actual contains confidential information, a mockup that faithfully represents sufficient rows for a test) on OneDrive or GoogleDrive with a link pasted here that grants access?
See if this works when you add more rows. (For future reference, when somebody requests a sample database with sufficient rows for a test, that would normally mean more than a single row. This was simple enough that I'm pretty sure it'll suffice.)
=(COUNTIF(K5:O5,"Yes")+COUNTIF(K5:O5,"Waiver"))/COUNTA(K5:O5)