G
Gregory Day
I currently have the following formula.
=IF(ISERROR(COUNTIF(Clients!$AB:$AB,A33)),"",COUNTIF(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?
=IF(ISERROR(COUNTIF(Clients!$AB:$AB,A33)),"",COUNTIF(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?