sum cells from separate sheets

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

  1. tedesco24 macrumors member

    Jul 4, 2010
    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

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


    Jul 7, 2009
    = 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

    Jul 4, 2010

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

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

Share This Page