Show Dash Rather Than Zero

[Calvin Nguyen]

I have a long SUMIF formula in a cell. If the SUMIF doesn't find any matches, I'd like to display a dash or hyphen rather than a zero.

Is there a way of doing this other than an IF that uses the same formula for both the logic test and value parameters? Performance and duplication concerns aside, there's also the problem of cell contents doubling in size and becoming very unreadable due to the length of each of my SUMIFs alone.

[shg]

Format the cells as, for example, 0;;-

[martindwilson]

or format cells a accounting no symbol

[BradleyS]

How about using an IF statement

=IF(A1=0,"-","Add sumif formula here")

[Calvin Nguyen]

shg and martin, you dudes are awesome.