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
Bookmarks