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 each requirement are YES, WAIVER, or NO. Both YES and WAIVER count as the requirement being met.

I need to determine the percentage of those 5 requirements as being met.

The formula I tried is =COUNTIF(K5:O5,{ “YES”, “WAIVER”})/COUNTA(K5:O5)

Unfortunately I keep getting an error saying that I’ve entered too few arguments for the function. If I try copy and pasting the code from elsewhere it turns into #SPILL!

I have also tried =COUNTIF(K5:O5, “YES”)+COUNTIF(K5:O5,”WAIVER”)/COUNTA(K5:O5) which somehow results in 400%, even if I have one of the requirements listed as not being met.

What am I missing?

​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 each requirement are YES, WAIVER, or NO. Both YES and WAIVER count as the requirement being met. I need to determine the percentage of those 5 requirements as being met. The formula I tried is =COUNTIF(K5:O5,{ “YES”, “WAIVER”})/COUNTA(K5:O5) Unfortunately I keep getting an error saying that I’ve entered too few arguments for the function. If I try copy and pasting the code from elsewhere it turns into #SPILL! I have also tried =COUNTIF(K5:O5, “YES”)+COUNTIF(K5:O5,”WAIVER”)/COUNTA(K5:O5) which somehow results in 400%, even if I have one of the requirements listed as not being met. What am I missing?  Read More

​