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 :
<tbody>
</tbody>
and on the following week a new table arrives:
<tbody>
</tbody>
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:
<tbody>
</tbody>*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
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 :
A | B | C | D | |
A | 2 | 4 | 1 | |
B | 1 | 2 | 6 | |
C | 1 | 1 | 1 | |
D | 5 | 1 | 1 |
<tbody>
</tbody>
and on the following week a new table arrives:
F | A | W | B | |
F | 2 | 4 | 1 | |
A | 1 | 2 | 6 | |
W | 1 | 1 | 1 | |
B | 5 | 1 | 1 |
<tbody>
</tbody>
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:
A | B | C | D | F | W | |
A | S | S | S | S | S | |
B | S | S | S | S | S | |
C | S | S | S | S | S | |
D | S | S | S | S | S | |
F | S | S | S | S | S | |
W | S | S | S | S | S |
<tbody>
</tbody>
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