linking sheets in workbook

[Guest]

I would like to summarise 20 sheets in the same workbook.
I have a list of data in column A and then 6 lists of totals in columns B to
G, on each sheet.
I would like to add together the totals e.g. all the totals in column B
together from each sheet, identified with the data in column A
Although the data in column A is similar it is not identical and on the same
line on each sheet. The summary sheet has all the data from column A.

I started to use Vlookup putting the data into new columns on the summary
sheet, and had 120 columns 6 from each sheet then just us a basic sum when
all the data had fed into the summary sheet, but this proved to make the
workbook really slow.

has anybody got any other idea?

Thanks

 

[Anne Troy]

Joe, maybe this will help:
http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm

If you have difficulty because totals are "at the bottom" but not in the
same row, consider inserting a row at the very top, and using row 1 as your
totals instead.
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Hello

I have tried below, and it works superb - but not all of the data i want to
sumarise is on the same line on each sheet.

so i want to do something like this
=SUMIF(First:Last!A1:A202,A26,First:Last!B1:B202), but it is returning a
#value.

What am i missing?

help, and thanks

-----------------------------------------------------------------------------------------------------------------


Suppose your worksheets aren't in any kind of sequential order. Or you have
50 worksheets, and you only want to sum 30 of them, but you're constantly
adding worksheets, so the beginning and end worksheet names may change?

In this case, place a blank worksheet to the left of the first worksheet you
want to include in the formula. Call that worksheet "First". Insert another
blank worksheet after the last worksheet you want to include in the formula.
Call that worksheet "Last". You can even hide these worksheets!

Then, your formula will be:

=SUM(First:Last!A2)