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.