How do I sum across multiple worksheets in Excel?

Question

I have several worksheets in an excel document (for example they are numbered one, two, three, four, and five. I need to add the number found in cell C36 of worksheets "one" "two" "three" and "four", and then display that total in cell b3 on worksheet "five".

How do I do this? Keep in mind these are all worksheets in the same excel file using Excel from Office XP.

Answer 1

theres several ways to do this.
heres 1
in cell b3
- type +
- click on cell c36
- type +
- click worksheet "two"
- click on cell 36 in that sheet
- type +
- click on worksheet three
and just keep doing that til you get all 4 sheets....then finally hit the enter key.

Answer 2

Excel Sum Across Sheets

Answer 3

when you type in =SUM( in the formulas box, you will see a little box with a red dot. Click that and then click the cells you want to add. Make sure you put the + in after each cell you click on. You can select cells in different worksheets.

Answer 4

=SUM(Sheet1:Sheet4!C36)