If Formula with Sum to replace 0 with Hyphens

[Manny74]

Hi All, I am trying to create a formula to replace a blank or zero with a hyphen for each quarter...I feel as though I am close to figuring this out.
for 1st Qtr, I typed =IF(C3+D3+E3=0,"-",SUM(C3:E3)) and it seemed to work..
But couldn't I type =IF(SUM C3:3=0,"-",SUM(C3:E3)) ?

COLUMN

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

ROW 2

Jan

Feb

Mar

1st Qtr

Apr

May

June

2nd Qtr

July

Aug

Sept

3rd Qtr

Oct

Nov

Dec

4th Qtr

ROW 3

Complaints

-

0

0

0

 

[Fluff]

How about
=IF(SUM(C3:E3)=0,"-",SUM(C3:E3))

 

[VBE313]

just add an E instead of ":3" do ":E3"

 

[Manny74]

When I use =IF(SUM(C3:E3)=0,"-",SUM(C3:E3)) I get #NAME?

 

[Manny74]

Oh sorry, I mistyped the formula....
But when I try =IF(SUM C3:E3=0,"-",SUM(C3:E3)) I get the following message (see attached image)

 

[Fluff]

That's because it's no a valid formula.

 

[VBE313]

Oh sorry, I mistyped the formula....
But when I try =IF(SUM C3:E3=0,"-",SUM(C3:E3)) I get the following message (see attached image)

=IF(SUM(C3:E3)=0,"-",SUM(C3:E3)) This works for me

 

[Scott Huish]

=IF(SUM(C3:E3),SUM(C3:E3),"-")

or you could just use =SUM(C3:E3) and format the cells as:
General;-General;-

 

[Joe4]

Why go through all the trouble of using formulas?
Just use a Custom Format to show the dash for zero values, like Scott says.

The issue with returning text values it is going to preclude you from using those values in any other mathematical computations (i.e. you would not be able easily use those values in other sums, etc).

 

[Manny74]

=IF(SUM(C3:E3),SUM(C3:E3),"-") worked, thank you!