Sum more than 2 tables based on 1st row and column names

[BioPA]

Hi there!

I wish everyone has a very happy new year and my special wishes to Mr.Excel staff for supporting us!

I would be grateful, if you could help me on the problem below:

Imagine that on week 1 i have a new table like this below :

[TABLE="width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]5
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

and on the following week a new table arrives:

[TABLE="width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[TD]W
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]F
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]W
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]5
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

And actually every week a similar table arrives which may have from 5 to 14 (named rows and columns on any order. I exclude the 1st top left cell as it is always blank)


How can i Create a new table with the sums of the values above:

[TABLE="width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]F
[/TD]
[TD]W
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD][/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]S
[/TD]
[TD][/TD]
[TD]S[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD][/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S[/TD]
[TD][/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]F
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD][/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]W
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD]S
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
*S=Sum

Remark: It's up to you to instruct me of how i will sort the weekly tables (horizontally or vertically) on a single sheet
The new sum table to be placed on a 2nd sheet


Thank you very much!

Regards

 

[BioPA]

edit:

Apart from the new table, it will be very useful to have 2 columns with the possible combinations and their sum value

A A 0
A B 5
A C 6
A D 14

 

[BioPA]

Anyone to contribute?