HELP! Excel questions!

Discussion in 'Mac Apps and Mac App Store' started by kakkoiimac, Nov 4, 2006.

  1. kakkoiimac macrumors regular

    Joined:
    Sep 29, 2006
    Location:
    Paradise
    #1
    I am pretty new to the whole macrumors community...so i hope it is ok to post a question like this here. I work as a computer tutor at a college and i had a question that i couldnt awnser. In MS Excel 2004 for students can you add up different cells in 4 different worksheets in the same workbook and get that total on worksheet 5? Any help with this question would help me out a ton. I know you can add up the same cell in all four but im not sure if the four cells are different. thanks so much!

    -
    mac
     
  2. WildCowboy Administrator/Editor

    WildCowboy

    Staff Member

    Joined:
    Jan 20, 2005
    #2
    Sure...it would be formatted something like this:

    =SUM(Sheet1!D25+Sheet2!A5+Sheet3!E12+Sheet4!B4)
     
  3. kakkoiimac thread starter macrumors regular

    Joined:
    Sep 29, 2006
    Location:
    Paradise
    #3
    ah..yeah...im stupid...i should have known that...thanks a ton!
     
  4. Caezar macrumors 6502

    Joined:
    Jun 9, 2004
    Location:
    Between a rock and a hard place
    #4
    Actually, you can directly type the formula like this. The Sum function is not necessary.

    =Sheet1!D25+Sheet2!A5+Sheet3!E12+Sheet4!B4
     

Share This Page