Excel formuler help please

[Andybtsn]

This is probably going to be quite easy for those in the know but unfortunately I have forgotten just about everything I ever learnt in Excel.

Me and my friend play Pro Evo on the Xbox 360 and record the scores so we can have a league going with wins, losses, points and goal difference. We play three games and record them.

This is how it is laid out..

Basically I'm manually changing the league to input the date, what formulers do I need to use to get the league to look at the scores and fill out all the respective columns.

Any help appreciated.

Thanks

 

[Andybtsn]

div0, that is fantastic, very much appreciated

One thing though, I have copied the formula down on F2, but no scores means a draw so it shows about 3000 draws at the moment!

Is it possible to create another IF saying if there is no score there then do nothing rather than account it as being a draw?

Thanks a lot,

Andy

 

[Andybtsn]

Great

Thanks a lot!

Andy