Pass Fail percentage when columns are non-contiguous

[tonenp1968]

I am working on a spreadsheet of mostly pass or fail that has comments spaced throughout it. The person who made the spreadsheet used this formula to achieve a pass or fail percentage:

=COUNTIF(M18:AX18,"Pass")/COUNTA(M18:AX18)

But it counts the columns that have comments as a fail so it doesn't give a true percentage. After the Pass / Fail section starts there are 5 columns of comments spaced out through the rest of the spreadsheet. What is the formula to count only pass or fail and nothing else, either by what it says or by what column it is on?

Thank you in advance for help.
Tony P.

 

[Eric W]

Welcome to the MrExcel Bulletin Board.

Maybe:

=COUNTIF(M18:AX18,"Pass")/(COUNTIF(M18:AX18,"Pass")+COUNTIF(M18:AX18,"Fail"))

 

[tonenp1968]

Welcome to the MrExcel Bulletin Board.

Maybe:

=COUNTIF(M18:AX18,"Pass")/(COUNTIF(M18:AX18,"Pass")+COUNTIF(M18:AX18,"Fail"))

That worked perfect! I have been working on this for hours! Thank you so much!

 

[Eric W]

You're welcome! Sometimes it just takes another pair of eyes.