- For calculating singles, doubles, triples,... etc. we need to count, the corresponding runs taken against each over.
- The different steps that we can follow are shown here.
1. Add columns with names as "Total 1's, Total 2's, .....":
![](/media/7/8/f/176e1bf9871ee318a3e47b9fe1eb5acd3fcd5797b3ec41ba431cd34ae3b51.gif)
![](/media/7/8/f/176e1bf9871ee318a3e47b9fe1eb5acd3fcd5797b3ec41ba431cd34ae3b51.gif)
2. Add entries into corresponding columns as, number of times that corresponding columns' runs taken in each over:
![](/media/0/6/1/ac39c7b5f8cf5e5d0b00e3a01409f56b27db9786300d6f6147377cb4e335b.gif)
![](/media/0/6/1/ac39c7b5f8cf5e5d0b00e3a01409f56b27db9786300d6f6147377cb4e335b.gif)
3. If any corresponding columns' runs are not taken, in a particular over, then enter "zero" in that corresponding cell of column and row:
![](/media/4/d/d/27043ffb0c5b60e31390079692a41c3420903fba9548c78da520f62a00efa.gif)
![](/media/4/d/d/27043ffb0c5b60e31390079692a41c3420903fba9548c78da520f62a00efa.gif)
4. If any wide ball is bowled in an over, then consider it in singles. Likewise if we have "3Wd" then it will be counted as "3" runs:
![](/media/8/6/2/d4677eafab8ae801e738a60362a32020aeef607ea9e9b362f8328d7078bd0.gif)
![](/media/8/6/2/d4677eafab8ae801e738a60362a32020aeef607ea9e9b362f8328d7078bd0.gif)
5. Calculate total occurrences for each columns "Total 1's, Total 2's, ...." using "SUM" function, by providing it cell range of that whole column:
![](/media/3/4/1/0d6c87400f5e7b34a395411714dee35e3e41781c372f8c6f1ec1995e80909.gif)
![](/media/3/4/1/0d6c87400f5e7b34a395411714dee35e3e41781c372f8c6f1ec1995e80909.gif)
6. Use auto completion functionality to calculate for other columns:
![](/media/2/d/0/52af108cded1e95a8183a6197dfa17e2158f412c1545af3709cc468813725.gif)
![](/media/2/d/0/52af108cded1e95a8183a6197dfa17e2158f412c1545af3709cc468813725.gif)
7. Totalling Columns:
- We calculated total number of occurrences of that particular column's run.
- Now we need to calculate the total runs against each column's runs.
- For doing so, we have to multiply "number of occurrences" with "runs, that particular column representing".
8. Calculating innings final total:
- After completing the above process, add all the columns' total, to get inning final total.
- For this, Write "SUM(" function and select the cell range, which is displaying total runs taken as singles, doubles, .... etc.
- Match the calculated new total with "Innings Total Runs" final total, which should be same.
![](/media/d/3/6/2a8a7fae1f96b4c62e62ef7869687d7f892f10243a4b07335f1e5256c77c9.gif)
[Contributed by administrator on 15. März 2018 15:07:04]