zero cell dividing by a zero cell

[Jane Collins]

I am using this formula to return a count then dividing by a number cell to give a percentage. this formula does work except when the count result is zero and the dividing cell is also zero.

How can I edit my formula to show a zero instead of #DIVO! but keep the same formula to?

=COUNT(IF(Open!$B$2:$B$5000=$C136,IF(Open!$A$2:$A$5000=E$2,IF(Open!$H$2:$H$5000=$D136,Open!$H$2:$H$5000))))/E$81

 

[Richard Schollar]

Hi Jane

This should work:

=IF(E$81=0,0,COUNT(IF(Open!$B$2:$B$5000=$C136,IF(Open!$A$2:$A$5000=E$2,IF(Open!$H$2:$H$5000=$D136,Open!$H$2:$H$5000))))/E$81)

Confirmed with Ctrl+Shift+Enter

Best regards

Richard

 

[Jane Collins]

Thank you - it does work!