Dynamic Scoreboard

[indygo]

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

	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>
</tbody>

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)

Row\Col	A​	B​	C​	D​	E​	F​	G​	H​
1​	Score Team A	Score Team B	Set1	Set1	Set2	Set2	Set3	Set3
2​	2​	1​	21​	19​	19​	21​	21​	10​

 

[indygo]

thank you both

 

[indygo]

thank you both