Thanks for this. The folks who are comfortable with Excel can deal with a
formula update.

What I was hoping for was someway to "code out" the individual number rather
than changing the formula. This is for a form that many people use and not
all of them are good with formulas.


"Gary''s Student" wrote:

Let's say we have numbers in cells A1 thru A100. Say we want the sum, but
want to exclude A13. The formula to use is:


=SUM(A1:A12)+SUM(A14:A100)


--
Gary's Student


"dj" wrote:

Is there a way to show a number in a column, yet not have it included in the
total?
The example would be to show how much an item would cost but strike it out
because that item is being included at no charge. This is for Excel 2000.

Thanks for any help.