Hello everybody, I am an Excel beginner and happy to be here!
I am using this formula, =COUNTIF(F5,"Yes")/(COUNTIF(F5,"Yes")+COUNTIF(F5,"No")), to be able to calculate the success rate of "Yes" and ignore N/A. It is working fine but when I try to do some more calculations I am getting the #DIV/0! error.
Is there a way to use the iferror function in order to manually change the DIV error to N/A? That way my first formula will work without issues.
Thank you in advance!
Bookmarks