12 Replies Latest reply: Oct 4, 2011 6:14 AM by Wayne Contello
inte Level 1 Level 1 (10 points)

Massively basic question - how do you use the sum function in Numbers?

 

Long-time Excel user, new to Numbers. Finding lots of information telling me where the function is, but it doesn't do anything.

 

The only way I've found to create a sum of a range of cells is manually type a formula in a cell.

 

There must be a way to select a range of cells and create a sum. How?

  • vjdjr Level 2 Level 2 (185 points)

    Inte, if I'm understanding you correctly, you want to get an automatic SUM without typing in the function int a cell.

    Grab15.jpg

    Please note the shaded area in the lower left corner.  Once you highlight a group of cells, SUM, AVG, MIN, MAX, and COUNT are already filled in for you.  Should you wish to, you can drag any of these into a cell to house the function there.

     

    Vince

  • Badunit Level 6 Level 6 (11,400 points)

    If you would rather do it with a keyboard shortcut versus dragging the sum from the sidebar, you can create a shortcut for the menu item Insert/Function/Sum.  You make custom keyboard shortcuts in System Preferences/Keyboard.

  • Jerrold Green1 Level 7 Level 7 (29,925 points)

    There's one more method that I'm aware of, and it may be what you have in mind.

     

    If you have a column of numbers to add, you can select it and then click on the Function Icon in the Toolbar. From there when you choose SUM, you will get a SUM expression for your list of numbers in the row following the last entry selected.

     

    If the last entry was in the last row of your table, the sum will be added, again, just below the last entry, in a Footer Row, even if no Footer Row previously existed.

     

    Jerry

  • Level 8 Level 8 (41,790 points)

    Jerrold Green1 wrote:

     

    There's one more method that I'm aware of, and it may be what you have in mind.

     

    If you have a column of numbers to add, you can select it and then click on the Function Icon in the Toolbar. From there when you choose SUM, you will get a SUM expression for your list of numbers in the row following the last entry selected.

    In fact it behave the same if you select the lower cell in the column before triggering the SUM menu item.

    At first think, I assumed that it was because empty cells are treated as cells containing 0 but it's not that.

    If the bottom cell contain an explicit zero, when I select it, the SUM menu item is disabled.

     

    Yvan KOENIG (VALLAURIS, France) lundi 3 octobre 2011 14:08:51

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

    My iDisk is : <http://public.me.com/koenigyvan>


    Please : Search for questions similar to your own before submitting them to the community

  • Jerrold Green1 Level 7 Level 7 (29,925 points)

    Yvan,

     

    I can't reproduce your "function disabled" observation.

     

    When a range is not specified by Selection, I note that sometimes the assumed range is horizontal. Curious how that is derived.

     

    Jerry

  • Level 8 Level 8 (41,790 points)

    Hello

    Maybe I was not clear enough.

    At top the selected cell is empty. The functions are enabled.

    2011-10-03T16.11.56.jpg

    At bottom, the selected cell is filled. The functions are disabled.

    I get that under 10.6.8 and 10.7.x

     

    Yvan KOENIG (VALLAURIS, France) lundi 3 octobre 2011 16:20:23

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

    My iDisk is : <http://public.me.com/koenigyvan>


    Please : Search for questions similar to your own before submitting them to the community

     

     

  • Jerrold Green1 Level 7 Level 7 (29,925 points)

    I am not surprised by the unavailability of the statistics functions in the case of a single cell selection because the statistic on a single value is trivial.

     

    Jerry

  • Level 8 Level 8 (41,790 points)

    No more trivial that when the cell is blank. In this case it returns the sum, the mean, the min, the max, the product of the values above.

    2011-10-03T17.46.31.jpg2011-10-03T17.46.57.jpg

     

    Yvan KOENIG (VALLAURIS, France) lundi 3 octobre 2011 17:48:43

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

    My iDisk is : <http://public.me.com/koenigyvan>


    Please : Search for questions similar to your own before submitting them to the community

     

     

  • Jerrold Green1 Level 7 Level 7 (29,925 points)

    Well, I have to disagree.

     

    1. When we select a range of cells with content in more than one of them, the requested function is inserted below.

    2. When we select a cell that is blank, we get the requested function operating on the cells above or to the left.

     

    Selecting a single cell with content is an example of case 1. above, but a single cell range result is trivial, i.e., the same as the content for all but the Product function, undefined for a single operand.

     

    Similarly, selecting a blank cell just below a single cell with numeric content has the same lack of significance.

     

    Jerry

  • Level 8 Level 8 (41,790 points)

    Hello Jerrold

     

    What about these examples :

     

    2011-10-04T09.49.06.jpg2011-10-04T09.50.20.jpg

     

    I selected the blank cell then triggered the Functions button.

     

    Yvan KOENIG (VALLAURIS, France) mardi 4 octobre 2011 09:53:26

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

    My iDisk is : <http://public.me.com/koenigyvan>


    Please : Search for questions similar to your own before submitting them to the community

     

     

  • Jerrold Green1 Level 7 Level 7 (29,925 points)

    KOENIG Yvan wrote:

     

    Hello Jerrold

     

    What about these examples :

     

    I think that the Apple software engineers didn't consider every possible case

     

    Jerry

  • Wayne Contello Level 6 Level 6 (15,215 points)

    It seem when you select a cell and use the menu item "Insert > Function > Sum" there are several possibilities.  Based on my experiments the following outcomes are possible (in priority):

     

    * except for headers

     

    1)  column => row = n

    sums in the same column from row 1 to (n-1) *

     

    2) (Column = n) > Row

    sums in the same row from Column 1 to (n-1) *