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

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

--


Regards,


Peo Sjoblom

"Tonso" <wthomasss@hotmail.com> wrote in message
news:657614d1-0925-4646-9d6d-6b07d2eb83d9@59g2000hsb.googlegroups.com...
> 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

On Aug 28, 1:01*pm, "Peo Sjoblom" <peo.sjob...@mvps.org> wrote:
> Not really. There is no format so everything you do needs labour
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Tonso" <wthoma...@hotmail.com> wrote in message
>
> news:657614d1-0925-4646-9d6d-6b07d2eb83d9@59g2000hsb.googlegroups.com...
>
>
>
> > 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- Hide quoted text -
>
> - 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

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

"Tonso" <wthomasss@hotmail.com> wrote in message
news:d1d11e2c-e82d-413c-9cef-46d00f018774@73g2000hsx.googlegroups.com...
On Aug 28, 1:01 pm, "Peo Sjoblom" <peo.sjob...@mvps.org> wrote:
> Not really. There is no format so everything you do needs labour
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "Tonso" <wthoma...@hotmail.com> wrote in message
>
> news:657614d1-0925-4646-9d6d-6b07d2eb83d9@59g2000hsb.googlegroups.com...
>
>
>
> > 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- Hide quoted text -
>
> - 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

On Aug 28, 1:33*pm, "Peo Sjoblom" <peo.sjob...@mvps.org> wrote:
> 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
>
> "Tonso" <wthoma...@hotmail.com> wrote in message
>
> news:d1d11e2c-e82d-413c-9cef-46d00f018774@73g2000hsx.googlegroups.com...
> On Aug 28, 1:01 pm, "Peo Sjoblom" <peo.sjob...@mvps.org> wrote:
>
>
>
> > Not really. There is no format so everything you do needs labour
>
> > --
>
> > Regards,
>
> > Peo Sjoblom
>
> > "Tonso" <wthoma...@hotmail.com> wrote in message
>
> >news:657614d1-0925-4646-9d6d-6b07d2eb83d9@59g2000hsb.googlegroups.com...
>
> > > 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- Hide quoted text -
>
> > - 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- Hide quoted text -
>
> - Show quoted text -

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

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 !
---------------------------------------------------------------------------
"Tonso" <wthomasss@hotmail.com> wrote in message
news:68e0e675-811d-47c6-b51b-a584cca775fa@j22g2000hsf.googlegroups.com...
On Aug 28, 1:33 pm, "Peo Sjoblom" <peo.sjob...@mvps.org> wrote:
> 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
>
> "Tonso" <wthoma...@hotmail.com> wrote in message
>
> news:d1d11e2c-e82d-413c-9cef-46d00f018774@73g2000hsx.googlegroups.com...
> On Aug 28, 1:01 pm, "Peo Sjoblom" <peo.sjob...@mvps.org> wrote:
>
>
>
> > Not really. There is no format so everything you do needs labour
>
> > --
>
> > Regards,
>
> > Peo Sjoblom
>
> > "Tonso" <wthoma...@hotmail.com> wrote in message
>
> >news:657614d1-0925-4646-9d6d-6b07d2eb83d9@59g2000hsb.googlegroups.com...
>
> > > 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- Hide quoted text -
>
> > - 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- Hide quoted text -
>
> - Show quoted text -

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