[Muddled]

Is it possible to make a sum cell not show a total when the value in one of
its source cells is zero? This is on an excell spreadsheet wher I have a
column for "Optional" items & don't want a total unless there is an amount in
the option cell.
--
Ralphy

[Jay Freedman]

On Sun, 13 May 2007 16:59:00 -0700, Muddled
wrote:

Is it possible to make a sum cell not show a total when the value in one of
its source cells is zero? This is on an excell spreadsheet wher I have a
column for "Optional" items & don't want a total unless there is an amount in
the option cell.

Umm... Try asking in an Excel newsgroup? This one is about Word.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.