Alternate method.

Hit SHIFT + F8 to get into ADD mode.

Click on desired cells without holding the CRTL key.

Hit F8 twice to get out of ADD mode. Or SHIFT + F8 again.


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 17:09:03 -0800, "tjtjjtjt"
wrote:

Try this:
In the cell you want to add in, type:
=SUM(
Then, Hold down Ctrl and Click on the cells you want to add together.
When you're done, type the closing ) and then press enter.

tj

"Kevin Gordon" wrote:

I'd like to be able to sum into a blank cell a series of non-consecutive
cells by clicking on them, i.e. by clicking in an empty cell and then hitting
= to start a formula and then clicking the cells I want to add one by one.
Excel 2002's default is to REPLACE the last cell clicked on when you click
after cells one after the other, I want them to add together. Some versions
of Excel (eg. Office 98 and X for Mac) do this by default. Can this be set
up in Office 2002 also?

Thanks in advance.