As we see above we have data for 5 batsmen playing cricket along with the scores in every match. So the consolidated score for 3 matches is available. Now in order to calculate what is the average score for each batsman is, here is how we go about calculating:
Put the =average formula and select the range of which you need to take an average. Now press enter and we arrive at the average score for the first batsman as below:
As we can see above the average score of 1st Batsman is 50.3 runs. Now in order to calculate for the remaining, just copy & paste the same formula.
Here you go. Now we have arrived at the average of the entire list of batsmen. We illustrated above how to calculate row wise, we can do the same column wise too (refer below):
And then you can copy and paste the same formula in rest of the columns.
Now you can easily calculate the average of any given data.

## Average In MS Excel 2007

Let us learn how to calculate an average of any data. For this consider the table below:

April 24, 2010 at 8:58 AM

thanks for the info..... , i was getting trouble on average now its clear for me thanks again.....

May 5, 2010 at 3:01 PM

Thanks, I always seem to forget these simple things. Will bookmark your post for future reference.

May 5, 2010 at 3:44 PM

Thanks, I always seem to forget these simple things. Will bookmark your post for future reference.

May 31, 2010 at 10:16 PM

Thanks for this deemonstration

June 4, 2010 at 12:20 AM

Thanks!

-Ken

Core Bits

July 30, 2010 at 9:01 PM

Mnay thanks

Online Learning

Online Training