Thread: Trying to get rid of the #DIV/0
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
UlvaZell UlvaZell is offline
external usenet poster
  
Posts: 10
Default Trying to get rid of the #DIV/0
=IF(ISERROR(SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0))),"
",SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)))

"UlvaZell" wrote:

Combine the ISERROR function with an IF statement...

"Matt" wrote:

I have this formula in my cell but Can I get rid of the#DIV/0?



The formula in the cell is =SUM(B38:O38)/(COUNT(B38:O38)-COUNTIF(B38:O38,0)
Reply With QuoteReply With Quote