Good evening
How would I add values of 4 tables who share the same first column holding 8 identical descriptions/cells, while the columns have the first, descriptive row and numerical values below? Some column headers are shared, others are unique.
The tables have the following layout
E F G H I J
A 0 2 3 1 5 1
B 0 0 7 2 3 2
C 2 3 4 6 0 0
D 0 3 4 9 1 0
E X G H Y I J W
A 4 2 3 1 5 1 3 2
B 1 0 4 2 3 2 0 3
C 0 3 4 6 0 0 1 4
D 7 3 4 9 1 0 2 1
The desired result would be:
E F G H I J X Y W
A 4 2 6 2 6 4 2 5 2
B 1 0 11
C 0 etc.
D 7
Is it possible to summarize all cell values of all 4 tables, positions AE, AF, AG.... BE... CH...DW within respective tables?
The actual Excel file containing 4 sheets of data is in attachment.
Thank you in advance.
