Hiding Zeros
 

In cell C13 I have =SUM(T9:Z9) Cell C13 displays a zero (0) if there is
nothing in cell T9. How do code the sum statement in C13 to be blank unless
there is a value in T9?

--

Regards
Michael Koerner

Hiding Zeros
 

=if(T9 = "", "",SUM(T9:Z9))
--
HTH...

Jim Thomlinson


"Michael Koerner" wrote:

In cell C13 I have =SUM(T9:Z9) Cell C13 displays a zero (0) if there is
nothing in cell T9. How do code the sum statement in C13 to be blank unless
there is a value in T9?

--

Regards
Michael Koerner

Hiding Zeros
 

Thanks, and much appreciated. I guess I left off the = before the if which
is where I was getting my error message.

--

Regards
Michael Koerner


"Jim Thomlinson" wrote in
message ...
| =if(T9 = "", "",SUM(T9:Z9))
| --
| HTH...
|
| Jim Thomlinson
|
|
| "Michael Koerner" wrote:
|
| In cell C13 I have =SUM(T9:Z9) Cell C13 displays a zero (0) if there is
| nothing in cell T9. How do code the sum statement in C13 to be blank
unless
| there is a value in T9?
|
| --
|
| Regards
| Michael Koerner
|
|
|
|