format a cell so a number in cell will not be included when using the"sum" feature in the status bar

[Tonso]

Using XL2002, I have a spreadsheet where i enter numbers frequently in
vairous cells. I would like to be able to select an area, then get the
"sum" from the right side of the status bar. There are some cells in
the area that i do not want included in the sum. It would be too time
consuming to select a group of indivdual cells using the Ctrl key, and
since I enter the numbers frequently it is inconvenient to precede the
numbers i dont want included in the sum with an apostrophe. Using the
Text format does not help. Is there a custom number format i can use
in the cells i do not want included in the sum, or some other more
practical solution?

Thanks,

Tonso

 

[Peo Sjoblom]

Not really. There is no format so everything you do needs labour

--


Regards,


Peo Sjoblom

 

[Tonso]

Not really. There is no format so everything you do needs labour

--

Regards,

Peo Sjoblom






- Show quoted text -

Thanks Peo. Not what I wanted to hear, but at least now i know. Thanks
again. I really appreciate all the help you contributors provide here.
Tonso

 

[Peo Sjoblom]

You can name part of the ranges if it is always the same ranges you want the
sum from

Which means you do a one timer using ctrl to pick the cells and then do
insert>name>define and give the selection a name

Then you just do


=SUM(MyName)


then you do the same for another selection of cells



--


Regards,


Peo Sjoblom

Not really. There is no format so everything you do needs labour

--

Regards,

Peo Sjoblom






- Show quoted text -

Thanks Peo. Not what I wanted to hear, but at least now i know. Thanks
again. I really appreciate all the help you contributors provide here.
Tonso

 

[Tonso]

You can name part of the ranges if it is always the same ranges you want the
sum from

Which means you do a one timer using ctrl to pick the cells and then do
insert>name>define and give the selection a name

Then you just do

=SUM(MyName)

then you do the same for another selection of cells

--

Regards,

Peo Sjoblom






Thanks Peo. Not what I wanted to hear, but at least now i know. Thanks
again. I really appreciate all the help you contributors provide here.
Tonso- Hide quoted text -

- Show quoted text -

Peo,
The areas will vary, so that approach will not work. But, thanks
again!
Tonso

 

[RagDyer]

If the areas will vary, how come you're asking for a special cell format?

You would have to apply that format to specific cells ... wouldn't you?

Sounds like you're not too clear in your own mind as to what you're looking
to do.

If you're able to format a cell, you're able to work with Peo's suggestion.
--
Regards,

RD

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

You can name part of the ranges if it is always the same ranges you want
the
sum from

Which means you do a one timer using ctrl to pick the cells and then do
insert>name>define and give the selection a name

Then you just do

=SUM(MyName)

then you do the same for another selection of cells

--

Regards,

Peo Sjoblom






Thanks Peo. Not what I wanted to hear, but at least now i know. Thanks
again. I really appreciate all the help you contributors provide here.
Tonso- Hide quoted text -

- Show quoted text -

Peo,
The areas will vary, so that approach will not work. But, thanks
again!
Tonso