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

[Special-K]

Use this formula in the K column

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

[Leo Heuser]

"Ed O'Brien" <[email protected]> skrev i en meddelelse
news:[email protected]...
>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))


--
Best regards
Leo Heuser

Followup to newsgroup only please.

[Ed O'Brien]

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

Best wishes,

Ed


"Leo Heuser" <[email protected]> wrote in message
news:[email protected]...
> "Ed O'Brien" <[email protected]> skrev i en meddelelse
> news:[email protected]...
>>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))
>
>
> --
> Best regards
> Leo Heuser
>
> Followup to newsgroup only please.
>

[Leo Heuser]

"Ed O'Brien" <[email protected]> skrev i en meddelelse
news:[email protected]...
> 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


"Special-K" <[email protected]> skrev i
en meddelelse news:[email protected]...
>
> Use this formula in the K column
>
> =IF(SUM(C3:J3)=0,"",SUM(C3:J3))
>
>
> --
> Special-K
>
>
> ------------------------------------------------------------------------
> Special-K's Profile:
> http://www.excelforum.com/member.php...fo&userid=7470
> View this thread: http://www.excelforum.com/showthread...hreadid=562509
>