Sum multiple pages, NOT in order

[Tim]

I would like to sum the same cell in each sheet, but the sheets are not in order......(ie. there are sheets in between the sheets I want to sum).
Is there some function like sum(sheet1:sheet20,$o$60) that I can use to add multiple sheets not in order
Thanks for anyone's help or ideas.....
Tim

 

[charlie]

Tim,

Let's say the total you want, is going to be in sheet1
cell A1.

With the cursor in A1, type "=(Sum" with out the quotes
Then go to sheet2, click on the cell to sum, go to sheet20
and click on the cell to sum, go to sheet60 and so on.
When the final sheet is reached click enter.

Charlie O'Neill

-----Original Message-----
I would like to sum the same cell in each sheet, but the

sheets are not in order......(ie. there are sheets in
between the sheets I want to sum).

Is there some function like sum(sheet1:sheet20,$o$60)

that I can use to add multiple sheets not in order?

 

[Guest]

oops it should be "=sum(" sorry.
Charlie O'Neill

-----Original Message-----
Tim,

Let's say the total you want, is going to be in sheet1
cell A1.

With the cursor in A1, type "=Sum(" with out the quotes
Then go to sheet2, click on the cell to sum, go to sheet20
and click on the cell to sum, go to sheet60 and so on.
When the final sheet is reached click enter.

Charlie O'Neill

sheets are not in order......(ie. there are sheets in
between the sheets I want to sum).
that I can use to add multiple sheets not in order?
.

 

[firefytr]

don't forget to seperate w/ a "," comma after each selection