My first question on EE!
I have a series of tables (see attached file) and I need to be able to count the the number of times each value appears against their respective row headers and table footers.
For example - in the table there are Tables called 'Scenario 1', 'Scenario 2' and 'Scenario 3'.
I need to produce a Summary Tables that counts the number of times each number appears in all 3 scenario tables against the respective row and footer identifiers.
For example, in Scenario 1, the number 1 (see highlighted cells) is present as an E/L , as a P/M and as an E/T.
In Scenario 2, the number 1 is present as an P/M, E/M and an E/T
In Scenario 3, the number 1 is present as a P/L, E/T and E/M.
What I really need is the for 'Summary' table to populate itself - so that I can change things around in the top 3 tables and try and balance out the Summary tables across the column headers.