Adding the numbers in the right cell

[Spikyd]

Hello!

Thank you for your time if you wanna try helping me! :D
I don't understand how to solve this problem, download the excel file to see.
There are 3 tables :
1 for first round
1 for second round
1 for final

In the first table is a prediction of mine of 2-1 (points) for red team
In the second table is another prediction of 3-1 (points) for blue team
In the final table where is the red cell with border i wanna find out a function or formula that can add up the procentages from the first table (first round 2-1) and second table (second round 1-3) and complete into the final table
Cause 2-1 + 1-3 = 3-4 final score
and if i try use AVERAGE function (D3 with M3, D4 with M4, etc) the max procentage will not go in the RED cell, i mean, it makes no sense.
Hope i explained that you can understand what i ment to say.
Have a nice day!

[AliGW]

Why do your tables need to be laid out in this way? Why is the result shown as 100%? What are you not telling us that may be significant here?

[Spikyd]

With other words, the max value from first table (could be at the score of 4-4 points) and with the max value from second table (1-1 score of points) can't match in the right cell... the procentages i will not write them manually, they could change their value form the table, all i wanna know how i can make that be possible, if it is possible. Thanks!

[Spikyd]

First question :
Cause i make it in this way, seems to be more easier visually for me, and is cute :D
Second question :
Why 100% ? I write manually that procentage, i there is 100% in other cells from the table is 0% because all cells added up from 0-0, 1-1, 1-0, 0-1 etc ... to 5-5 will result a 100% procentage... i hope you understand me
3rd question :
I try to explain : If i write a formula in the cell Z6 where is the RED cell, i need the max value from the first table like how is right now on the E5 BUT is connecting with the 2 points for red team and 1 point for blue team and also need the max value from second table where is P4 connecting with 1 point for red team and 3 points for blue team... but the max values from first 2 tables can change... Idk if i explained enough to understand.

The final score as i said before is RED TEAM 3 - 4 BLUE TEAM
If i use the AVERAGE function in the final table, the max procentage will not go in the RED cell to connect with 3 points for red team and 4 points to blue team. will be in one cell 50% and in other 50% but not in the red cell
please look at this excel file

[AliGW]

Cause i make it in this way, seems to be more easier visually for me, and is cute :D

Bad move. You should lay your data out to facilitate the calculations, not to be aesthetically pleasing.

Sorry - you are making it far more complex than it needs to be.