Newbie : Sum Cells Part 2

  • Thread starter Thread starter RM
  • Start date Start date
R

RM

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
 
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
 
Back
Top