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

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