sum cells from separate sheets

Discussion in 'Mac Apps and Mac App Store' started by tedesco24, Apr 27, 2011.

  1. tedesco24 macrumors member

    Joined:
    Jul 4, 2010
    #1
    I have a Numbers file that contains two separate sheets. Is there a function that I can use to take data from a cell on sheet #2 and combine it with data from a cell on sheet #1?
     
  2. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #2
    Yes, but you have to add the sheet reference to the cell reference.
     
  3. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #3
    = Sheet1!A1 + Sheet2!B3

    Is that what you're looking for? You can do it inside Numbers as well. Just type = then click on the cell in the sheet you want, then type + and click on the other cell on the other sheet. It will automatically create the references for you.
     
  4. tedesco24 thread starter macrumors member

    Joined:
    Jul 4, 2010
    #4

    That did the trick, thank you.
     
  5. blevins321 macrumors 68030

    Joined:
    Dec 24, 2010
    Location:
    Winnipeg, MB
    #5
    Try to say the title of this thread 3 times fast. You just invented a new techno tongue twister.
     

Share This Page