Hi
I'm struggling to get a countif formula working in a spreadsheet. With the example sheet I've posted, I'm trying for each "Bowler", I am trying to count, for example, how many times 0 runs are scored for the ball.
Any help anyone could provide would be much appreciated.
Thanks
Jamie
Excel 2007
I'm struggling to get a countif formula working in a spreadsheet. With the example sheet I've posted, I'm trying for each "Bowler", I am trying to count, for example, how many times 0 runs are scored for the ball.
Any help anyone could provide would be much appreciated.
Thanks
Jamie
| Excel Workbook | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| G | H | I | J | K | L | M | N | O | P | Q | |||
| 45 | Bowler | Runs | |||||||||||
| 46 | Chris L | 1 | 0 | 1 | 0 | 1 | |||||||
| 47 | Chris L | -5 | 1 | 3 | |||||||||
| 48 | Trav | 2 | 2 | ||||||||||
| 49 | Trav | 5 | 0 | 3 | 2 | ||||||||
| 50 | Miles | 1 | 1 | ||||||||||
| 51 | Miles | 1 | -5 | 0 | -5 | 0 | |||||||
| 52 | Dean | 2 | 0 | 3 | |||||||||
| 53 | Dean | -5 | 0 | -5 | |||||||||
| 54 | Pidge | 2 | 1 | 2 | |||||||||
| 55 | Pidge | -5 | 2 | 2 | |||||||||
| 56 | Ryan | 0 | 3 | -5 | 1 | ||||||||
| 57 | Ryan | 1 | 1 | 2 | |||||||||
| 58 | John | 1 | 1 | ||||||||||
| 59 | John | 0 | 0 | 1 | 0 | ||||||||
| 60 | Dingo | 2 | 0 | 1 | 3 | ||||||||
| 61 | Dingo | 1 | 1 | 2 | 1 | ||||||||
RD 1 - Game 1 | |||||||||||||
