Sum multiple pages, NOT in order

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: charlie (anonymous_at_discussions.microsoft.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 13:15:52 -0800

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 *** is reached click enter.

Charlie O'Neill

>-----Original Message-----
>I would like to sum the same cell in each ***, 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
>.
>

Quantcast