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

 

[Manny74]

So for Total CY19, I simply entered =SUM(F3+J3+N3+R3)...
How can I create an If formula to place a hyphen in the cell if 1st QTR + 2nd QTR+3rd QTR+4th QTR equals zero?

COLUMN

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

ROW 2

Jan

Feb

Mar

1st Qtr

Apr

May

June

2nd Qtr

July

Aug

Sept

3rd Qtr

Oct

Nov

Dec

4th Qtr

Total CY19

ROW 3

Complaints

-

0

0

0

ROW 4

Grievances

ROW 5

Positive Feedback

ROW 6

Neutral Feedback

ROW 7

Negative Feedback

ROW 8

Total Surveys

 

[Scott Huish]

Same way we did before:

=IF(SUM(F3,J3,N3,R3),SUM(F3,J3,N3,R3),"-")

or without the SUM:
=IF(F3+J3+N3+R3,F3+J3+N3+R3,"-")

 

[Manny74]

When I used =IF(SUM(F3,J3,N3,R3),SUM(F3,J3,N3,R3),"-") I got a #VALUE! message...

 

[Scott Huish]

Does your version of Excel require semicolons instead of commas?

 

[Manny74]

I'm not sure, I have Microsoft Excel 2013...

 

[Fluff]

Do you normally use commas in your formulas?

Also do any of F3, J3, N3 or R3 contain #VALUE!

 

[Manny74]

Wait, it seems to work now....maybe I missed something, but it works now...thanks!!

 

[Manny74]

So I used this formula to display hyphens when the cells are zero: =IF(SUM(F3,J3,N3,R3),SUM(F3,J3,N3,R3),"-")

But for 1st Quarter, what if Jan, Feb & March were truly zero, so then I would want 1st quarter to say zero.....

So it seems, if the cells are blank, there should be a hyphen in the appropriate Qtr....but if the cells have zeros, then the quarter should have a zero in it....

What formula would provide this?

COLUMN

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

ROW 2

Jan

Feb

Mar

1st Qtr

Apr

May

June

2nd Qtr

July

Aug

Sept

3rd Qtr

Oct

Nov

Dec

4th Qtr

Total CY19

ROW 3

Complaints

0

0

0

-

-

-

-

ROW 4

Grievances

ROW 5

Positive Feedback

ROW 6

Neutral Feedback

ROW 7

Negative Feedback

ROW 8

Total Surveys

 

[Fluff]

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

 

[Manny74]

That worked, thanks so much!!!