In my forms, I have several questions that can result as either PASS, FAIL or N/A. I want to express only the FAIL cells as a percentage over the entire row results. I've been using this formula:
=COUNTIF(CellName1@row:CellName2@row, CONTAINS("PASS", @cell)) / 7
The only way I've been able to make this work is by counting all of the PASS cells and dividing the result by the number of cells (7) I want to compare it to.
This has drawbacks:
-As long as all of my answers are either Pass or Fail, the percentage expresses correctly. But, when I choose N/A, the expression fails.
-I also can't express this result WITHOUT counting the PASS cells.
Ideally, I want this formula to say something such as "Count all cells in row that have the word "FAIL" in them, compare that to the total number of cells I wanted to check, and tell me the total as a percentage."
How do I accomplish this?