Forum Discussion

cornucopia's avatar
cornucopia
Copper Contributor
Nov 04, 2021
Solved

SUM!?

Where am I going wrong?  I've used Excel for years.  When it comes to adding up cells in the column above, I've merely inserted = and then clicked on each above cell which highlights in a different c...
Excel on Mac
JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Nov 04, 2021

cornucopia  wrote:  ``I've merely inserted = and then clicked on each above cell which highlights in a different color.``

 

I am not familiar with Excel for Mac.  But I am quite sure that Excel for Windows has never behaved exactly that way.  I suspect that you forgot some details.

 

In any case, in my version of Excel (Excel 2010 for Windows), the following works as you describe for my example:  select E5; click AutoSum (upper right) -- no need to type "="; press and hold Ctrl, then click each cell; release Ctrl and press Enter.  Caveat: AutoSum might be in a different position of the toolbar in your version.

 

 

Note: The image assumes that you selected the option "Allow editing directly in cells".  In my version of Excel, click File > Options > Advanced.  Otherwise, the colored cell names appear in the Formula Bar.

Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Nov 04, 2021
Even that way its necessary to type the delimiter (comma). Because when A1 is selected and then you select B1, without delimiter it using comma, the last click will be the range for the formula.
  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor
    Nov 04, 2021

    Juliano-Petrukio  wrote: ``Even that way its necessary to type the delimiter (comma).``

     

    No. But I made a critical error when I typed the description.  I edited the posting with the correction.  Reread and try again.  Sorry.

Resources