Calculate averages

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

Originally Posted by MagicMan0027

Hi .....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 aver.............

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

I w..........Thanks

Welcome to the Forum.

I'm taking that the highest score is already included in the Total amount of runs.

Example:

Cells:
A1 = Amount of innings
B1 = Times not out
C1 = Total amount of runs
D1 = Highest score
E1 = Where the formula will be placed.

=C1/(A1-B1)

Hope that helps


Cheers

ratcat

Originally Posted by ratcat

Welcome to the Forum.

I'm taking that the highest score is already included in the Total amount of runs.

Example:

Cells:
A1 = Amount of innings
B1 = Times not out
C1 = Total amount of runs
D1 = Highest score
E1 = Where the formula will be placed.

=C1/(A1-B1)

Hope that helps


Cheers

ratcat

Yes highest score already included in total.

Thank you I will try it.

I would like to be able to just enter each player's runs scored after every game and the average will be automatically adjusted. I don't know if it's possible. The list will contain about 20 players.

Thanks

Originally Posted by MagicMan0027

I would like to be able to just enter each player's runs scored after every game and the average will be automatically adjusted. I don't know if it's possible. The list will contain about 20 players.

Thanks

G'day MagicMan007,

It can be done. You are going to upload an example (a zip file) or explain the layout of the where the data is going to be entered.

How do you want to display the not out ?