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

How about: =IF(A33="","",COUNTIF(Clients!$AB:$AB,A33))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gregory Day" wrote:
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

Holy Cow! That was perfect. I always miss the obvious. Can you tell me how to
et the same answer on this one? What is happening here is that Excel is
calculating on those empty cells from the previous question. Excel sees an
empty cell as a "0" the calculation is, correctly, returning a "0" result. I
would rather the cell stay blank as well. I tried using the "" but, since 0
IS a valid answer, that is what I am getting.

=IF(ISERROR(SUM(SUMIF(Clients!$AB:$AB,Summary!A33, Clients!$AE:$AE),(SUMIF(Clients!$AB:$AB,Summary!A3 3,Clients!$AF:$AF)))),"",SUM(SUMIF(Clients!$AB:$AB ,Summary!A33,Clients!$AE:$AE),(SUMIF(Clients!$AB:$ AB,Summary!A33,Clients!$AF:$AF))))

How I make this leave the cell blank if the answer is "0"?

--
Thank you,

Gregory


"Max" wrote:

How about: =IF(A33="","",COUNTIF(Clients!$AB:$AB,A33))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gregory Day" wrote:
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

A simple way out, if it's more just for a neat look in the sheet is to switch
off zeros display via clicking Tools Options View tab Uncheck "zero
values" ok

Otherwise, you could try inserting the IF check for zero returns,
indicatively like this in your formula:
=IF(ISERROR(SUM(...)),"",IF(SUM(...)=0,"",SUM(..)) )

Do press the "Yes" button from where you're reading this
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gregory Day" wrote:
Holy Cow! That was perfect. I always miss the obvious. Can you tell me how to
et the same answer on this one? What is happening here is that Excel is
calculating on those empty cells from the previous question. Excel sees an
empty cell as a "0" the calculation is, correctly, returning a "0" result. I
would rather the cell stay blank as well. I tried using the "" but, since 0
IS a valid answer, that is what I am getting.

=IF(ISERROR(SUM(SUMIF(Clients!$AB:$AB,Summary!A33, Clients!$AE:$AE),(SUMIF(Clients!$AB:$AB,Summary!A3 3,Clients!$AF:$AF)))),"",SUM(SUMIF(Clients!$AB:$AB ,Summary!A33,Clients!$AE:$AE),(SUMIF(Clients!$AB:$ AB,Summary!A33,Clients!$AF:$AF))))

How I make this leave the cell blank if the answer is "0"?