Collating/ Summarising worksheets
 

Is there any way of collating worksheets such that one sheet summaries all
the information in the other worksheets when the cells do not necessarily
coincide?



For example,



Sheet1 has

A B

1 Australia 3

2 Brazil 2

3 Total 5



Sheet2 has

A B

1 Australia 1

2 Bangladesh 1

3 Brazil 5

4 Thailand 7

5 Total 14



And I would like to produce a summary sheet that looks like this



Sheet3 has

A B

1 Australia 4

2 Bangladesh 1

3 Brazil 7

4 Thailand 7

5 Total 19





This would save me a lot of time. I can guarantee that there are no spelling
mistakes or formatting differences for any of my data. Thanks for your help



Cheers

Collating/ Summarising worksheets
 

Paste this in cell B1 on sheet 3:
=SUMIF(Sheet1!A:B,A:A,Sheet1!B:B)+SUMIF(Sheet2!A:B ,A:A,Sheet2!B:B)
Copy down the column.

The above method is not very efficient because it requires another formula
for each sheet.


"James" wrote:

Is there any way of collating worksheets such that one sheet summaries all
the information in the other worksheets when the cells do not necessarily
coincide?



For example,



Sheet1 has

A B

1 Australia 3

2 Brazil 2

3 Total 5



Sheet2 has

A B

1 Australia 1

2 Bangladesh 1

3 Brazil 5

4 Thailand 7

5 Total 14



And I would like to produce a summary sheet that looks like this



Sheet3 has

A B

1 Australia 4

2 Bangladesh 1

3 Brazil 7

4 Thailand 7

5 Total 19





This would save me a lot of time. I can guarantee that there are no spelling
mistakes or formatting differences for any of my data. Thanks for your help



Cheers