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.