Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF - #DIV/01
Hi I have the following formula - =COUNTIF(StatusCheck, "Snag Item")/COUNTIF(ElementCount,"Main Contractor - Builderswork") StatusCheck and ElementCount are named ranges. The formula works - however when nothing is entered on the spreadsheet (the formula has nothing to count) it displays #DIV/01. Is there anything I can add to the formula to stop this happening? Any help would be great. Cheers, Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |