How can I prevent the "division by zero" error in this formula

W

Watercolor artist

if one of its cells is either null or blank?

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

Thanks.
 
N

N Harkawat

=SUMPRODUCT((C5:C65<>"Ginny
cancelled")*(A5:A65<>"")/(COUNTIF(A5:A65,A5:A65&"")))
 
Top