Hiding a Zero Result

[Ed O'Brien]

I am adding/subtracting cells C3 to J3 along a row with the result showing
in K3. When nothing is entered K3 shows a zero which I want to hide so when
I copy down the sheet to 52 weeks I don't have a column full of zeros.

I have tried =IF(C3:J3=0," ",C3:J3) and =IF(C3:J3=" "," ",C3:J3) but neither
work. In K3 I get nothing, not even when an entry is made along the row. In
cells where formulae is picking up the answer in K3 I get either #VALUE or
#####.

Can anyone help with this, please?

TIA

Ed

 

[Leo Heuser]

I am adding/subtracting cells C3 to J3 along a row with the result showing
in K3. When nothing is entered K3 shows a zero which I want to hide so when
I copy down the sheet to 52 weeks I don't have a column full of zeros.

I have tried =IF(C3:J3=0," ",C3:J3) and =IF(C3:J3=" "," ",C3:J3) but
neither work. In K3 I get nothing, not even when an entry is made along
the row. In cells where formulae is picking up the answer in K3 I get
either #VALUE or #####.

Can anyone help with this, please?

TIA

Ed

Hi Ed

One way:

=IF(COUNT(C3:J3)=0,"",SUM(C3:J3))

 

[Special-K]

Use this formula in the K column

=IF(SUM(C3:J3)=0,"",SUM(C3:J3)

 

[Ed O'Brien]

Great! Thanks, Leo. Works a treat. Never thought of COUNT!

Best wishes,

Ed

 

[Leo Heuser]

Great! Thanks, Leo. Works a treat. Never thought of COUNT!

Best wishes,

Ed

You're welcome, Ed, and thanks for the feedback

Leo

 

[Leo Heuser]

SUM(C3:J3) may be zero, if the range contains both
positive and negative numbers.

Leo Heuser