Spreadsheet: 112837d1308829210-needa-formula-to-find-data-from-group-of-cells-cricket-2-
Sheet: Score Book

 |  |  |  |  |  |  |  | .................................................................................................. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRICKET CLUB   v         .......................................................................................................... |  |  |  |  |  |  |  | CRICKET CLUB |  |  |  |  | CaptaIns.....(h).......................................
Weather  ................. |  |  |  | INNINGS OF   ..................................................................................... |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLAYED AT     ............................................................................................. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ON      .........................................................    20   ...................... |  |  |  |  |  | ....(a).......................................
Batsman |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Runs Scored |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In/Out | mins | Balls | 4 | 6 | How Out | Fielder | Bowler | Total | SR
1
A Bat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
2
B Bat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
3
C Bat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
4
D Bat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | #N/A
 | 6 | AA |  | 3 | CC |  | 0 | WW | m | 0 | YY | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Over |  | Runs | Wkts | Total |  | Runs | 0
Bowler 1 | 1 | 2 | . | 1 | . | . |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | AA |  |  | 0 |  | Extra,s | 8
 | 3b | w | . | . | . | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er |  |  |  | 2 | BB |  |  | 0
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6 | 12 | 6 | 1 |  | 0 | 0 | 6 | 12 | 3 |  |  |  | 3 | CC |  |  | 0 |  | TOTAL | 8
no balls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | DD |  |  | 0
 | 1 | 6 | 3 | 0 | 6 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | EE |  |  | 0 |  | Wickets | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | FF |  |  | 0
 | 2 | BB |  | 5 | DD |  | 0 | XX | m | 0 | ZZ | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | GG |  |  | 0
Bowler 2 | . | . | . | 1 | 2 | . |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 2 |  |  |  |  |  |  |  |  |  |  |  | 8 | HH |  |  | 0 |  |  | Runs
 | . | . | . | . | w | 2lb |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er |  |  |  | 9 | II |  |  | 0 |  | Wides | 1
wides | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6 | 14 | 5 | 1 |  | 1 | 1 | 5 | 6 | 2.5 |  |  |  | 10 | JJ |  |  | 0 |  | No Balls | 0
no balls | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | KK |  |  | 0 |  | Byes | 4
 | 0 | 8 | 2 | 1 | 6 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | LL |  |  | 0 |  | 1b | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | MM |  |  | 0 |  | 2b | 0 | 0
 | 7 | EE |  | 8 | GG |  | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | NN |  |  | 0 |  | 3b | 3 | 1
Bowler 3 | 1 | . | . | 6 | . | . |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 3 |  |  |  |  |  |  |  |  |  |  |  | 15 | OO |  |  | 0 |  | 4b | 0 | 0
 | 2 | 4 | . | 1lb | 1b | w |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er |  |  |  | 16 | PP |  |  | 0 |  | [NAME] | 3
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6 | 12 | 13 | 1 |  | 0 | 0 | 13 | 12 | 6.5 |  |  |  | 17 | QQ |  |  | 0 |  | 1lb | 1 | 1
no balls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | RR |  |  | 0 |  | 2lb | 2 | 1
 | 0 | 6 | 7 | 1 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | SS |  |  | 0 |  | 3lb | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | TT |  |  | 0 |  | 4lb | 0 | 0
 | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | UU |  |  | 0 |  | Total Extras | 8
Bowler 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 4 |  |  |  |  |  |  |  |  |  |  |  | 22 | VV |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er |  |  |  | 23 | WW |  |  | 0
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 |  | 0 | 0 | #N/A | #N/A | #N/A |  |  |  | 24 | XX |  |  | 0
no balls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | YY |  |  | 0 |  | score | mins | balls
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | ZZ |  |  | 0 |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | AB |  |  | 0 |  | 100
 | 0 | FF | m | 0 | HH | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | CD |  |  | 0 |  | 150
Bowler 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 5 |  |  |  |  |  |  |  |  |  |  |  | 29 | EF |  |  | 0 |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er |  |  |  | 30 | GH |  |  | 0 |  | 250
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 |  | 0 | 0 | #N/A | #N/A | #N/A |  |  |  | 31 | IJ |  |  | 0 |  | 300
no balls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | KL |  |  | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | MN |  |  | 0 |  | Score | Batsman | mins | part/Ship
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | OP |  |  | 0 | 1
 | 0 | LL | m | 0 | RR | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | QR |  |  | 0 | 2
Bowler 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 6 |  |  |  |  |  |  |  |  |  |  |  | 36 | ST |  |  | 0 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er |  |  |  | 37 | UV |  |  | 0 | 4
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 |  | 0 | 0 | #N/A | #N/A | #N/A |  |  |  | 38 | WX |  |  | 0 | 5
no balls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | YZ |  |  | 0 | 6
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | BA |  |  | 0 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | DC |  |  | 0 | 8
 | 0 | II | m | 0 | KK | m | 0 | SS | m | 0 | UU | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | FE |  |  | 0 | 9
Bowler 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 7 |  |  |  |  |  |  |  |  |  |  |  | 43 | HG |  |  | 0 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er |  |  |  | 44 | JI |  |  | 0
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 |  | 0 | 0 | #N/A | #N/A | #N/A |  |  |  | 45 | LK |  |  | 0
no balls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | NM |  |  | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | PO |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | RQ |  |  | 0
 | 0 | JJ | m | 0 | MM | m | 0 | TT | m | 0 | VV | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | TS |  |  | 0
Bowler 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 8 |  |  |  |  |  |  |  |  |  |  |  | 50 | VU |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 |  | 0 | 0 | #N/A | #N/A | #N/A
no balls
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | NN | m | 0 | PP | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m
Bowler 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 |  | 0 | 0 | #N/A | #N/A | #N/A
no balls
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | OO | m | 0 | QQ | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m | 0 |  | m
Bowler 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowler 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er
wides |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 |  | 0 | 0 | #N/A | #N/A | #N/A
no balls
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bowled
Caught |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Bowling Stats
LBW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | M | B | R | W |  | wd | nb | av | sr | er
Run Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 74 | 38 | 24 | 3 |  | 1 | 1 | 8 | 12.66666666666667 | 4
Stumped
Hit Wkt