I am using Excel 97.

Sorry for the double post guys. I forgot to ask this in the first post.

I have a problem where the cells I have to add up are all over the place in
the spreadsheet. What would be the best way to add them up?

Rich

Hi Rich

didn't see your first post but
one way, is to select all the cells that you want to add up( click on first
cell, hold down control key, click on all other cells while holding down the
control key)
then click in the name box (left of formula bar)
type a name for the range (no spaces) and press ENTER

now in the cell where you want the total type
=SUM(rangename)
where range name is the name you typed into the name box.

hope this helps
Cheers
JulieD

"RM" wrote in message
hlink.net...

I am using Excel 97.

Sorry for the double post guys. I forgot to ask this in the first post.

I have a problem where the cells I have to add up are all over the place
in
the spreadsheet. What would be the best way to add them up?

Rich

Julie/Rich

FYI only.

If you hit SHIFT + F8 you will see ADD on status bar right-side.

This allows click-selection of non-contiguous cells without holding the CRTL
key down.

You can sip your coffee while selecting cells.

SHIFT + F8 or hit F8 twice to get out of ADD mode.

Gord Dibben Excel MVP

On Tue, 24 Feb 2004 12:49:21 +0800, "JulieD"
wrote:

Hi Rich

didn't see your first post but
one way, is to select all the cells that you want to add up( click on first
cell, hold down control key, click on all other cells while holding down the
control key)
then click in the name box (left of formula bar)
type a name for the range (no spaces) and press ENTER

now in the cell where you want the total type
=SUM(rangename)
where range name is the name you typed into the name box.

hope this helps
Cheers
JulieD

"RM" wrote in message
thlink.net...

I am using Excel 97.

Sorry for the double post guys. I forgot to ask this in the first post.

I have a problem where the cells I have to add up are all over the place
in
the spreadsheet. What would be the best way to add them up?

Rich

good tip ... thanks ... now where's that coffee :)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Julie/Rich

FYI only.

If you hit SHIFT + F8 you will see ADD on status bar right-side.

This allows click-selection of non-contiguous cells without holding the
CRTL
key down.

You can sip your coffee while selecting cells.

SHIFT + F8 or hit F8 twice to get out of ADD mode.

Gord Dibben Excel MVP

On Tue, 24 Feb 2004 12:49:21 +0800, "JulieD"

wrote:

Hi Rich

didn't see your first post but
one way, is to select all the cells that you want to add up( click on
first
cell, hold down control key, click on all other cells while holding down
the
control key)
then click in the name box (left of formula bar)
type a name for the range (no spaces) and press ENTER

now in the cell where you want the total type
=SUM(rangename)
where range name is the name you typed into the name box.

hope this helps
Cheers
JulieD

"RM" wrote in message
thlink.net...

I am using Excel 97.

Sorry for the double post guys. I forgot to ask this in the first post.

I have a problem where the cells I have to add up are all over the
place
in
the spreadsheet. What would be the best way to add them up?

Rich