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.

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.

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

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.

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.

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.

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.

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.