How do I create a formula that pulls info. from many sheets within

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

Guest

I have a an excel file (Microsoft Excel 2003 version) that contains several
sheets. How do I create a new sheet with totals gathered from existing
sheets within the same excel file.
 
Assuming that the sheets are all of a standard format, the usual way is to
add a sheet at the start of them, say called 'First' and another at the end,
before your summary sheet, called say 'Last', and then use

=SUM(First:Last!A1)

The First and Lasst sheets can be hidden to avoid confusion.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
If the cells you want to sum are in different locations in each of the
worksheets you can use the following formula:

Sheet1!A1+Sheet2!A110

If they values are in the same cell in each worksheet you can use the
following:

SUM(Sheet1:Sheet3!A1)

Change the cell addresses as needed.
 
With formulas such as =SUM(Sheet1:Sheet2!A5)
You were not too specific so we do not know how the data is set out.
Try Help with the search term: consolidate
Try Google with search term: Excel consolidate sheets
One of the hits is
http://support.microsoft.com/kb/214270
Then come back when you can be more specific so we can help you better
best wishes
 
Back
Top