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

C

Carolina Girl

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.
 
B

Bob Phillips

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)
 
K

Kevin B

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top