Sum multiple pages, NOT in order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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)
Click to expand...
that I can use to add multiple sheets not in order?
 
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?
.
Click to expand...
 
Back
Top