Dynamic Scoreboard

[indygo]

So I'm trying to create dynamic scoreboard for Beach Volleyball

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Score Team A[/TD]
[TD="align: center"]Score Team B[/TD]
[TD="align: center"]Set1[/TD]
[TD="align: center"]Set1[/TD]
[TD="align: center"]Set2[/TD]
[TD="align: center"]Set2[/TD]
[TD="align: center"]Set3[/TD]
[TD="align: center"]Set3[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want excel to update A2 and B2 automatically based on c2,d2,f2,g2,h2,i2.
I guess it's simple because it has to simply compare if one cell is bigger than other and sum all IFs but I can't find the right formula..<d so="" on="" and="" sum="" it="" but="" i="" can't="" find="" the="" solution...<d="" results="" to="" a2="" b2="" solution.


Please help.</d>

 

[Muhammad_Usman]

Book1
	B	C	D	E	F	G	H	I
3	Score Team A	Score Team B	Set1	Set1	Set2	Set2	Set3	Set3
4	1	2	21	19	19	21	19	21
Sheet4

Cell Formulas
Range	Formula
B4	=IF(D4>E4,1,0)+IF(F4>G4,1,0)+IF(H4>I4,1,0)
C4	=IF(D4)+IF(F4)+IF(H4)

 

[strooman]

A2=SUM(C2>D2;E2>F2;G2>H2)
B2=SUM(D2>C2;F2>E2;H2>G2)

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][/tr][tr][td]

1​

[/td][td="bgcolor:#70AD47"]Score Team A[/td][td="bgcolor:#70AD47"]Score Team B[/td][td="bgcolor:#70AD47"]Set1[/td][td="bgcolor:#70AD47"]Set1[/td][td="bgcolor:#70AD47"]Set2[/td][td="bgcolor:#70AD47"]Set2[/td][td="bgcolor:#70AD47"]Set3[/td][td="bgcolor:#70AD47"]Set3[/td][/tr]
[tr][td]

2​

[/td][td="bgcolor:#FFFF00"]

2​

[/td][td="bgcolor:#FFFF00"]

1​

[/td][td="bgcolor:#E2EFDA"]

21​

[/td][td="bgcolor:#E2EFDA"]

19​

[/td][td="bgcolor:#E2EFDA"]

19​

[/td][td="bgcolor:#E2EFDA"]

21​

[/td][td="bgcolor:#E2EFDA"]

21​

[/td][td="bgcolor:#E2EFDA"]

10​

[/td][/tr]
[/table]

 

[indygo]

thank you both

 

[indygo]

thank you both