Quick question about Numbers and a quick "sum" function

Discussion in 'Mac Apps and Mac App Store' started by sun surfer, Mar 4, 2012.

  1. sun surfer macrumors regular

    Jun 6, 2010
    This seems like it should be easy but it's not.

    I've got a spreadsheet open with a big list. Each row has many separate numbers in many columns. I need each row added up with the sum shown in a separate box.

    I know I can do a quick sum row by row by selecting the row and choosing sum from the function list. But there's too many rows, so that would take a long time.

    I tried to select all the rows, but with multiple when I choose sum from the function menu, it adds down, not across. So I get a sum for each column, not each row.

    It just seems stupid that it doesn't have an easy way to change the quick sum to add across instead of down.

    And I've tried fooling with a formula for a column where I could say give me the sum for this row, for each row of this column. But I can't seem to figure out a way to do it en masse, so again I'd have to do it row by row as far as I can tell.

    Tell me I'm missing something and there's an easy way to accomplish what I want! Thanks.
  2. nielsrasmus macrumors member


    Dec 12, 2011
    If, you hoover the cursor to the lower right corner of the cell that contains the sum function it should turn into a black cross.

    Press the mouse button down and draw downwards.

    Then it should copy the the sum function for each row :)

    This is an old Excel trick, but works for Numbers as well :)

  3. sun surfer thread starter macrumors regular

    Jun 6, 2010
    Thanks! That works perfectly and will save me so much time. :)

Share This Page