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