Hello,

Here is what I would like to do and I am wondering if anyone can help me!

I have a set of data for test results which could be pass or fail - coded as "P" or "F". For each test type (in columns), for each person (in rows), the cell will have P, F, a combination, or may be blank if no test has yet been taken. What I would like to do is have formulas which will tell me:

1. How many people have passed in 1 attempt (i.e. the cell contains only 1 "P")
2. How many people required more than 1 attempt to pass (i.e. cell contains "FFP" or "FP", etc.)
3. How many people have only failed (regardless of how many times - therefore, cell could contain "F" or "FF" or "FFF").
4. How many people have not taken tests (I can probably figure this one out!)

I had previously gotten a formula below:
=SUMPRODUCT(LEN(P6:P31)-LEN(SUBSTITUTE(P6:P31,"P","")))

But this counts how many times "P" occurs in the range, and I want to know how many cells contain only a "P" (passed in 1 attempt), or how many cells contain some fails before a pass (required more than 1 attempt).

I hope someone can figure this out, as I truly do not want to have to count this all manually! Thank you!