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.


"Don Guillett" wrote:

must be homework since asked already today.
=sum(a1:a21)-a10

--
Don Guillett
SalesAid Software

"dj" wrote in message
...
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.