Hi there I'm a real newbie with Excel so excuse if questions are dumb.

I want to create a spreadsheet to calculate averages for sport.

It will be for cricket. The columns will be as follow:-

1. Amount of innings
2. Times not out
3. Total amount of runs
4. Highest score
5. Average

The average (column4) must be column 3 divided by (column 1 minus column 2)

So the average must be the total amount of runs scored divided by the amount of times out. (1 minus 2)

I would like to be able to just add scores after each game to calculate new average.

Hope I make sense.

Thanks