Excluding numbers in a total

D

dj

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.
 
G

Gary''s Student

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)
 
D

dj

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.
 
D

dj

Thanks, Gord.

As I replied to the first responder, this is for a form many people use and
not everyone is comfortable with formulas. I was hoping for a way to let the
number stand but "code it out" for those who don't want to tinker with the
formula. If not, so be it.
 
R

Ragdyer

Use the SUM() function to total your numbers, then, when you're entering the
value that you don't want included, simply prefix that value with an
apostrophe.

The SUM() function will ignore this "Text" number and not add it.
The apostrophe is not visible in the cell, but can be seen in the formula
bar when that cell is selected.
 
W

widman

I would add a column with some value, I normally use "X". you could use Y
for yes, then use sumif to sum the column of prices when the other column has
a Y.

you can make this as complicated as you want, to sum "Y" for non-tax, "T"
for taxables, etc.
 
Top