So I'm trying to create dynamic scoreboard for Beach Volleyball
<tbody>
A
B
C
D
F
G
H
I
1
Score Team A
Score Team B
Set1
Set1
Set2
Set2
Set3
Set3
2
2
1
21
19
19
21
21
10
3
</tbody>
I want excel to update A2 and B2 automatically based on c2,d2,f2,g2,h2,i2.
I guess it's simple...