Hi Paul:

Thank you for the response.

The "*" notation in this case means "or". I am saying to the cell, if
C8 or C9 or C10...or C13 are zero, then don't show anything in this
cell (untill all of the values are entered).

When I tried your equation and if I skipped a cell, it still computed
the sum of the remaining entered cells. I want the cell blank until all
of the values are entered. This way the user knows that there is a value
missing. If there is a final sum displayed, then they know that the have
entered values in all of the required cells.

Thank you again for your response.

Best Regards,
Thomas



--
thomasstyron
------------------------------------------------------------------------
thomasstyron's Profile: http://www.excelforum.com/member.php...o&userid=25568
View this thread: http://www.excelforum.com/showthread...hreadid=393933