Hi All & Happy Christmas & New Year,
I'm working on a World Cup spreadshhet. (Excel 2003)

In one section of it I've got the Group table
A B C D E F G H I

P W D L F A Pts GD
S. Africa

Below each table I've got the fixtures & these are what feed the above table.

Beside each team in the fixtures I've got seperate cells for W,D, & L. These
cells are each comparing the scores of each fixture & if True they're
resulting 1, if False they're 0.........

W D L Pts Team A Score Score Team B Pts W
D L
(The W to Pts are all hidden - they're formatted as White text)

The problem I'm having is with the Drawn games - even when the score cells
are empty (before any games have even been played) it's seeing this as True
so it's putting a "1" in the table for all teams so I'm ending up with a
table that shows that all teams have Played 3 & Drawn all 3 !!!!

For Draw I'm using
=IF(G11=H11,1,0)

The games Played are calculated by =Sum(cells W, D, & L) so I know that this
is why this isn't working as wanted, I know that once I get the Draw to = "0"
that this will sort out the Played bit.

What do I need to do to get the Draw Cell for each team in each fixture to
be "0" until a score has been entered?

Thanks in advance for any & all help.
John