=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