I'm not sure why you need a SUM formula - are you adding cells
together?

From your example, you could do this in C14:

=IF(B14<"",B14,"")

and then copy this down to C29.

Hope this helps.

Pete

On May 4, 5:14*pm, pen wrote:
In Excel 2003 I have a simple sum formula that is copied down the column. *
When I type in a value, it displays the answer all the way down the column. *
Is there a way to hide the answer in only the cells that are for rows where
no value is typed in?

For example: *Cell B14 has the value 2 in it, and cells C14 - C29 have the
total 2 displayed. *I just want the total of 2 displayed in only C14 and
hidden from C15 - C29.

Is this possible?