Simple Addition Function

[sneal]

I just converted from Office 2004 for Mac to Office 2007 on a PC. On the
Mac, + signs would automatically be entered as I clicked cells after entering
= (ie. =A1+A3+A5+A9.....). Now in 2007, it simply changes the first cell
information after the = sign is entered and the cells are clicked
(=A1....=A3.....etc.). I'm curious as to whether or not there is a setting
for this so entering the + sign can be avoided when adding non-bunched cells.
I know this may seem asinine, but this truly is a time saver in my
day-to-day operations.

 

[Meebers]

I use the =sum formula while holding down the control button and use the
mouse to select the cells I want added, the end result will look like
=SUM(a1,a3,a5 etc) This is "handy" when trying to add non adjacent cells.

 

[sneal]

Thanks for the reply Meebers. That seems easier than typing in the + between
each cell. I had just become so accustomed to being able to type = and then
click all the cells i wanted to add that now i'm slowed down by trying to
remember to include the plus sign.

 

[Meebers]

YW..forgot to add, I am sure you already know, but you can add adjacent and
non adjacent cells this way i.e. =sum(a1,a5,d4,g6:g10) etc