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. |
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) |