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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I prevent the "division by zero" error in this formula (https://www.excelbanter.com/excel-worksheet-functions/32667-how-can-i-prevent-%22division-zero%22-error-formula.html)

Watercolor artist

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.

N Harkawat

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

"Watercolor artist" wrote in
message ...
if one of its cells is either null or blank?

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

Thanks.

Watercolor artist

"N Harkawat" wrote:

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

"Watercolor artist" wrote in
message ...
if one of its cells is either null or blank?

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

Thanks.

Thanks.

All times are GMT +1. The time now is 02:23 AM.