And the winner is...

[tylertyler33]

Once the cells are filled for columns "1,2,3,4,5 and 6" I'd like a check mark (or any selected illustration) to automatically appear under the "Winner" column for the team with the most points. In the example below Team A defeats Team B 4.5-1.5. All cells are filled so can we get a check mark to appear. Thank you.

	1	2	3	4	5	6	Winner
Team A	1	0	0.5	1	1	1
Team B	0	1	0.5	0	0	0

<tbody>
</tbody>

 

[Scott T]

Excel 2010

	A	B	C	D	E	F	G	H
1		1	2	3	4	5	6	Winner
2	Team A	1	0	0.5	1	1	1	X
3	Team B	0	1	0.5	0	0	0

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Sheet6​

Worksheet Formulas Cell Formula H2 =IF(COUNT(B2:G3)=12,IF(SUM(B2:G2)>SUM(B3:G3),"X",""),"") H3 =IF(COUNT(B2:G3)=12,IF(SUM(B2:G2)<SUM(B3:G3),"X",""),"") <tbody> </tbody>

<tbody>
</tbody>

 

[tylertyler33]

It's possible Team B can be the winner as well. Currently, the formula doesn't support that. It works like a charm if Team A is the winner.

 

[Scott T]

The formula for H3 did not post right. remove the space around the <

=IF(COUNT(B2:G3)=12,IF(SUM(B2:G2) < SUM(B3:G3),"X",""),"")