My formula is:

SUMPRODUCT(--($A$3:$A$54="Business"),--($B$3:$B$54="Week 10"),$D$3:$D$54)

The thing is: I need it to display zero when the fomula picks up the value
zero. But even if the formula pick up blanks, this formula will return a
zero. That's the problem, please help!

Thank you.

"JLatham" wrote:

By all means, post the formula you're using - it will help us see how to best
advise you.

One typical way of dealing with something returning zero or an error is by
enclosing the operational portion within an if statement and returning "" if
a specific condition occures, otherwise perform the operation. Something
like this:

=IF(SUMPRODUCT(...)=0,"",SUMPRODUCT(...))
where SUMPRODUCT(...) is your formula that works other than returning and
displaying zero when you don't want to see that.


"mldancing" wrote:

I have a sumproduct formula that return zero, I tried to add

ISBLANK, ISNA, ISERROR

but couldn't replace the zeros with blanks.

Are there any other ways?

Thank you.