How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added?

I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0"
on the spreadsheet if nothing is inputed into any of the 3 other
cells.

How do i write the formula in cell D so that the "0" does not show on
the spreadsheet until numbers are put into any or all of cells A-C?


Radman

One way, in D1:
=IF(COUNTBLANK(A1:C1)=3,"",SUM(A1:C1))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Radman" <Radman@my.home> wrote in message
news:3rhfk1l2jde0fktlvj2p2u6gsl73gr5fr5@4ax.com...
>
>
> I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0"
> on the spreadsheet if nothing is inputed into any of the 3 other
> cells.
>
> How do i write the formula in cell D so that the "0" does not show on
> the spreadsheet until numbers are put into any or all of cells A-C?
>
>
> Radman

One way:

=IF(COUNT(A1:C1)=0,"",SUM(A1:C1))

In article <3rhfk1l2jde0fktlvj2p2u6gsl73gr5fr5@4ax.com>,
Radman <Radman@my.home> wrote:

> I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0"
> on the spreadsheet if nothing is inputed into any of the 3 other
> cells.
>
> How do i write the formula in cell D so that the "0" does not show on
> the spreadsheet until numbers are put into any or all of cells A-C?
>
>
> Radman

You could put in an equation where NA() is entered if the values entered in
A-C are blank. You could then conditionally format column D so that NA()
is formatted in the same color as the background.

"Radman" <Radman@my.home> wrote in message
news:3rhfk1l2jde0fktlvj2p2u6gsl73gr5fr5@4ax.com...
>
>
> I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0"
> on the spreadsheet if nothing is inputed into any of the 3 other
> cells.
>
> How do i write the formula in cell D so that the "0" does not show on
> the spreadsheet until numbers are put into any or all of cells A-C?
>
>
> Radman

Can a grumpy old ex-prof have a rant on this wet Saturday afternoon?
An enter such a =SUM(A1:A10) is a FORMULA.
A mathematical expression such as y=4x^2 + 4 is an EQUATION.
If we use the wrong terminology we will not find what we need in Help.
Happy Canadian Thanksgiving!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Barb Reinhardt" <reply@tonewsgroup.com> wrote in message
news:OVchdGBzFHA.2652@TK2MSFTNGP14.phx.gbl...
> You could put in an equation where NA() is entered if the values entered
> in A-C are blank. You could then conditionally format column D so that
> NA() is formatted in the same color as the background.
>
> "Radman" <Radman@my.home> wrote in message
> news:3rhfk1l2jde0fktlvj2p2u6gsl73gr5fr5@4ax.com...
>>
>>
>> I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0"
>> on the spreadsheet if nothing is inputed into any of the 3 other
>> cells.
>>
>> How do i write the formula in cell D so that the "0" does not show on
>> the spreadsheet until numbers are put into any or all of cells A-C?
>>
>>
>> Radman
>
>

Another option.....

Use a custom format to suppress the display of zero:

0;-0;;@

Biff

"Radman" <Radman@my.home> wrote in message
news:3rhfk1l2jde0fktlvj2p2u6gsl73gr5fr5@4ax.com...
>
>
> I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0"
> on the spreadsheet if nothing is inputed into any of the 3 other
> cells.
>
> How do i write the formula in cell D so that the "0" does not show on
> the spreadsheet until numbers are put into any or all of cells A-C?
>
>
> Radman

Hi,

You may also use conditional formatting. Go to Format>Conditional
formatting and sekect cell value>Equal t0>=0. Now select the font as White

Regards,

Ashish Mathur

"Radman" wrote:

>
>
> I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0"
> on the spreadsheet if nothing is inputed into any of the 3 other
> cells.
>
> How do i write the formula in cell D so that the "0" does not show on
> the spreadsheet until numbers are put into any or all of cells A-C?
>
>
> Radman
>