How To ignore blank cells....

Hi Guys,

Im exhausted making research on this matter...I am organizing a small football tournament of 4 teams each playing home and away accordingly... The standings table must show, Games Played, Won, Draw, Lost, Goal +, Goal -, Goal =, and Points.

Everything is working well except one...DRAW, since the scores have not been entered yet, the computer is reading the cell as if it is a draw even though they are empty... and the standings table is not set to 0 but 8 per team (8games). So there are 8 empty cells (since not started yet) which are being read as a Draw. ..I'm using the below function for the Home part :

=IF(D5=E5,1,0)+(E9=D9)+(E11=D11)+(D15=E15)

HOPE SOMEONE CAN HELP ME

Thanks
Maurizio

I'm not sure exactly how your data is laid out but if you have home score in D5 and away score in E5 and you want 1 for a draw but 0 otherwise try

=IF(AND(D5<>"",D5=E5),1,0)

or just

=AND(D5<>"",D5=E5)+0

This will only give a 1 if the cells are equal but not empty.

You can calculate in one formula how many draws in a range by extending that logic, e.g. to count draws in rows 5 to 15

=SUMPRODUCT((D5:D15<>"")*(D5:D15=E5:E15))