| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
"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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) | |||
| remainder in a division | Excel Worksheet Functions | |||
| Prevent change of color scheme in Pivot chart | Charts and Charting in Excel | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Linear Mode
