HELP! Excel questions!

[kakkoiimac]

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

 

[WildCowboy]

Sure...it would be formatted something like this:

=SUM(Sheet1!D25+Sheet2!A5+Sheet3!E12+Sheet4!B4)

 

[kakkoiimac]

ah..yeah...im stupid...i should have known that...thanks a ton!

 

[Caezar]

Actually, you can directly type the formula like this. The Sum function is not necessary.

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