IF(OR( Formula not adding correctly

I am trying to get a percentage of cells in a range that have "y" in the cell. The cells may have "y," "n," or "x" standing for complete, not complete, or not applicable. My formula is returning "#VALUE!"

Here is the formula:

=IF(OR(B6:B20="y",B6:B20="n"),COUNTIF(B6:B20,"y")/(COUNTIF(B6:B20,"y")+COUNTIF(B6:B20,"n")),1)

I added the "1" to the not true value if false so that it wouldn't be dividing by zero, but it still isn't working. Can someone please tell me what I am doing wrong?

Thanks,
Matthew Wilson

your testing a range of cells for Y or N

why does
=COUNTIF(B6:B20,"y")/((COUNTIF(B6:B20,"y")+COUNTIF(B6:B20,"n")))
not work for you - Not sure what the IF condition is trying to do here



you could use an iferror
=IFERROR(COUNTIF(B6:B20,"y")/((COUNTIF(B6:B20,"y")+COUNTIF(B6:B20,"n"))),1)
so if you get a div0 error it will give an answer of 1 - which I would not think you want "" will just leave the cell blank