Thread: How can I prevent the "division by zero" error in this formula
View Single Post
  #1   Report Post  
Watercolor artist
 
Posts: n/a
Default How can I prevent the "division by zero" error in this formula
if one of its cells is either null or blank?

=SUM(1/COUNTIF(A5:A65,A5:A65)*(C5:C65<"Ginny cancelled"))

Thanks.
Reply With QuoteReply With Quote