Autosum in Numbers

Discussion in 'Mac Apps and Mac App Store' started by qtrim, May 30, 2014.

  1. qtrim macrumors regular

    qtrim

    Joined:
    Oct 7, 2011
    #1
    I'm a long time user of Excel, trying to use Numbers now. In Excel I can highlight a list of numbers and click the 'autosum' button on the toolbar to have the formula added in the next cell. I can't figure out how to do that in Numbers, either on the Mac or the iPad, or the web version. Any help?
     
  2. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #2
    As far as I can tell, no, this doesn't exist. You need to type =sum( and then select the cells and press enter.
     
  3. qtrim thread starter macrumors regular

    qtrim

    Joined:
    Oct 7, 2011
    #3
    I can handle that. I was just missing the (

    Thanks.

     
  4. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #4
    Glad to help. Have a good day.
     
  5. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #5
    In Numbers it's a 2 step process. Though easier usually than typing in the formula. You can either select the cells you want summed, or merely place the cursor in the cell at the bottom of column or end of a row of numbers if they are standing on their own. Then in the toolbar at the top click the Function Browser icon and then Sum.

    It's Done...
     
  6. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #6
    snberk103, I don't think that this functionality is there any longer. Especially with the web version, there is no menu at the top.
     
  7. ApfelKuchen macrumors 68020

    Joined:
    Aug 28, 2012
    Location:
    Between the coasts
    #7
    In the iCloud version, there's no toolbar button for Functions. You type an '=' into the cell where you want to insert the formula, and that opens a sidebar from which you can select the desired function.

    In 3.x for Mac, there is a Function button on the toolbar. If you select a group of cells, click the Function button, and select a Function from the menu (Sum, Average, Minimum, Maximum, Count, Product), it will insert the results in the adjacent empty cell, just like AutoSum.

    Alternately, you could select the cell where you desire the results, click the Function button, and select the Function from the drop-down list - Numbers will then make an educated guess as to what range of cells you'd like to have summed/averaged, etc., just like Excel.

    My guess is that the developers consider this an enhancement of AutoSum, as more functions are available. However, I, too, would like a one-click solution - why not offer dedicated buttons for Sum, Average, Minimum, etc. that can be optionally added to the toolbar? I've made that, and several similar suggestions/requests to Apple (I'd also like to be able to add additional functions to the Functions drop-down, and be able to assign keyboard shortcuts...). Never hurts to add your suggestions to the pile.
     
  8. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #8
    This is all excellent information; thank you. I didn't know all of these different things! :D
     
  9. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #9
    I have purposely stayed away from the latest version - because of the lost functionality. So… it looks like I will need to specify the version I'm using. Thanks for the update.
     
  10. neutrino23 macrumors 68000

    Joined:
    Feb 14, 2003
    Location:
    SF Bay area
    #10
    Select a group of cells (vertical, horizontal or a rectangular selection) then at the bottom of the window you'll see the following:

    Sum Average Min Max CountA

    Select any one of those and drag it wherever you like to add that formula applied to the selected column of cells.

    If you select a cell you'll see an open circle in the upper left and lower right corners of the cell. Click and drag that to extend the selection, that is, to add more cells to the selection.

    If you hover over an edge you see a gold dot appear. Click and drag that to duplicate the cell contents in that direction.

    For example. If you select a column of cells and add the Sum function to a cell below that, you can click and drag right on the gold dot to create Sum functions for the columns of cells to the right of the first column.

    If the cell contains a number then dragging the gold dot repeats the number.

    If the cell contains a date then dragging the gold dot adds dates but increments the dates by one day per cell.
     

Share This Page