| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make a cell stay blank if "0" result?
I currently have the following formula.
=IF(ISERROR(COUNTIF(Clients!$AB:$AB,A33)),"",COUNT IF(Clients!$AB:$AB,A33)) This formula is repeated from Summary!D33 all the way to Summary!D65536 At this time, cell A33 is empty but will be populated later. Also, Clients!$AB:$AB is empty, but will be populated over time. Currently, I am getting a result of 65423, which is correct. There are in fact 65423 empty cells in Clients!$AB:$AB. I would like this cell to just stay blank (rather than show the number of blank cells) until such time as the cells referenced are populated over time. Is there anyway I can make this happen in this fashion? -- Thank you, Gregory |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show a blank result in a cell when there is no value in the "Lookup" cell | New Users to Excel | |||
| How create blank cell value as the result of Excel "IF" function? | Excel Worksheet Functions | |||
| How to format a cell to make it blank if it's content is "N/A" | Excel Worksheet Functions | |||
| How to make number of "static" fields stay the same when copying? | Excel Discussion (Misc queries) | |||
| Can you use a formula to make a truly "blank" cell | Excel Worksheet Functions | |||
Threaded Mode
