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"?