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?