[ms office - 2003] Help with a specific Excel query

[L_Smith]

Hello Everyone

 

First of all this is a personal request so I'm sorry if this should have gone somewhere else.

 

I will try to explain the best I can but I am useless with Excel.

 

Myself and a few friends are doing a pool league and I am trying to create a spreadsheet to calculate games played, games won, games lost, balls potted for, balls potted against and points.

 

The idea, is when someone has finished their game, they can input the results and it totals them up as they go along, then at the end of the night all the information is already there to compile the league table.

 

 

This is what it looks like so far. I'm struggling to work out how to calculate Games Played, Games won, Games Lost and Points. I have tried playing with the IF function but its like I'm banging my head against a brick wall

 

I would love it if anyone could point me in the right direction

[L_Smith]

Found out how to do it, but I have another question.

 

Does anyone know of any setting in Excel you can configure so that if a cell is blank, any calculation on that cell are ignored?