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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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

"Gord Dibben" wrote:

=SUM(A1:A10)-A6


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 16:18:02 -0700, 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.