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
|
|
|
|
|