Spreadsheet: 98430d1297333939-excel-2007-creating-a-formula-that-addresses-three-separate-columns-career-olsen-md
Sheet: Career Stats

 |  |  |  |  |  |  |  | [NAME]
 | Overall Career Batting & Fielding Stats
 | M | [NAME] | N.O. | Runs | Balls | HS |  | Avge | [NAME] | 50s | 0s | 50 P/S | c | b | lbw | st | ro | hw | S/R | 6s | 4s | St | Ct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Two-Day
 | Two-Day Batting & Fielding Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ltd Overs
 | M | [NAME] | N.O. | Runs | Balls | HS |  | Avge | [NAME] | 50s | 0s | 50 P/S | c | b | lbw | st | ro | hw | S/R | 6s | 4s | St | Ct |  |  | AMA20-20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Almar
 | Limited Overs Batting & Fielding Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bellville
 | M | [NAME] | N.O. | Runs | Balls | HS |  | Avge | [NAME] | 50s | 0s | 50 P/S | c | b | lbw | st | ro | hw | S/R | 6s | 4s | St | Ct |  |  | [NAME]
 |  |  |  |  |  |  | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brooklyn-Telkom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Claremont
 | AMA20-20 Batting & Fielding Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Durbanville
 | M | [NAME] | N.O. | Runs | Balls | HS |  | Avge | [NAME] | 50s | 0s | 50 P/S | c | b | lbw | st | ro | hw | S/R | 6s | 4s | St | Ct |  |  | Fish Hoek
 |  |  |  |  |  |  | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Overall Career Bowling Stats
 | Ovrs | Mdns | Runs | Wkts | c | b |  | lbw | st | hw | BB I | Avge | S/R | Econ | Wb | Nb | 5wI | 6s | 4s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green Point-CPUT
 | Two-Day Bowling Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kuils River
 | Ovrs | Mdns | Runs | Wkts | c | b |  | lbw | st | hw | BB I | Avge | S/R | Econ | Wb | Nb | 5wI | 6s | 4s |  |  |  |  |  |  | Langa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Montrose
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Northerns-Goodwood
 | Limited Overs Bowling Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oakdale
 | Ovrs | Mdns | Runs | Wkts | c | b |  | lbw | st | hw | BB I | Avge | S/R | Econ | Wb | Nb | 5wI | 6s | 4s |  |  |  |  |  |  | Pinelands
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Police
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Primrose
 | AMA20-20s Bowling Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Ovrs | Mdns | Runs | Wkts | c | b |  | lbw | st | hw | BB I | Avge | S/R | Econ | Wb | Nb | 5wI | 6s | 4s |  |  |  |  |  |  | Somerset West
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | St Augustines
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Overall Career [NAME] |  |  |  |  |  |  | Two-Day [NAME] |  |  |  |  |  | Ltd Overs Dismissal Breakdown |  |  |  |  |  | AMA20-20 [NAME] |  |  |  |  |  | Tygerberg
 | not out |  |  |  |  |  |  | not out |  |  |  |  |  | not out |  |  |  |  |  | not out |  |  |  |  |  | United
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | University of Cape Town
 | Caught WK / Slips |  |  |  |  |  |  | Caught WK / Slips |  |  |  |  |  | Caught WK / Slips |  |  |  |  |  | Caught WK / Slips |  |  |  |  |  | University of the Western Cape
 | Caught Gulley / Short catcher |  |  |  |  |  |  | Caught Gulley / Short catcher |  |  |  |  |  | Caught Gulley / Short catcher |  |  |  |  |  | Caught Gulley / Short catcher |  |  |  |  |  | Victoria
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | Western Province CC
 | Caught Infield |  |  |  |  |  |  | Caught Infield |  |  |  |  |  | Caught Infield |  |  |  |  |  | Caught Infield
 | Caught Outfield |  |  |  |  |  |  | Caught Outfield |  |  |  |  |  | Caught Outfield |  |  |  |  |  | Caught Outfield
 | Caught Unknown |  |  |  |  |  |  | Caught Unknown |  |  |  |  |  | Caught Unknown |  |  |  |  |  | Caught Unknown
 | Bowled |  |  |  |  |  |  | Bowled |  |  |  |  |  | Bowled |  |  |  |  |  | Bowled
 | LBW |  |  |  |  |  |  | LBW |  |  |  |  |  | LBW |  |  |  |  |  | LBW |  |  |  |  |  | [NAME], Elfindale
 | Run Out |  |  |  |  |  |  | Run Out |  |  |  |  |  | Run Out |  |  |  |  |  | Run Out |  |  |  |  |  | Bishop Lavis CC, [NAME]
 | Stumped |  |  |  |  |  |  | Stumped |  |  |  |  |  | Stumped |  |  |  |  |  | Stumped |  |  |  |  |  | [NAME] Oval, Plumstead
 | Hit Wicket |  |  |  |  |  |  | Hit Wicket |  |  |  |  |  | Hit Wicket |  |  |  |  |  | Hit Wicket |  |  |  |  |  | Chukker Road Sports Complex, Lansdowne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Durbanville
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Edgemead
 | Two-Day Wickets [NAME] |  |  |  |  |  |  | Two-Day Wickets [NAME] |  |  |  |  |  | Ltd Overs Wickets Taken Breakdown |  |  |  |  |  | AMA20-20 Wickets Taken Breakdown |  |  |  |  |  | Florida Park, Ravensmead
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | Green Point Track, Green Point
 | Caught WK / Slips |  |  |  |  |  |  | Caught WK / Slips |  |  |  |  |  | Caught WK / Slips |  |  |  |  |  | Caught WK / Slips |  |  |  |  |  | [NAME], Langa
 | Caught Gulley / Short catcher |  |  |  |  |  |  | Caught Gulley / Short catcher |  |  |  |  |  | Caught Gulley / Short catcher |  |  |  |  |  | Caught Gulley / Short catcher |  |  |  |  |  | Johnson Road Sports Fields, Rylands
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | Mutual Park, Pinelands
 | Caught Infield |  |  |  |  |  |  | Caught Infield |  |  |  |  |  | Caught Infield |  |  |  |  |  | Caught Infield |  |  |  |  |  | Northerns-Goodwood CC Oval, Goodwood
 | Caught Outfield |  |  |  |  |  |  | Caught Outfield |  |  |  |  |  | Caught Outfield |  |  |  |  |  | Caught Outfield |  |  |  |  |  | Pinelands Oval, Pinelands
 | Caught Unknown |  |  |  |  |  |  | Caught Unknown |  |  |  |  |  | Caught Unknown |  |  |  |  |  | Caught Unknown |  |  |  |  |  | PP Smit Complex, Bellville
 | Bowled |  |  |  |  |  |  | Bowled |  |  |  |  |  | Bowled |  |  |  |  |  | Bowled |  |  |  |  |  | [NAME], Somerset West
 | LBW |  |  |  |  |  |  | LBW |  |  |  |  |  | LBW |  |  |  |  |  | LBW |  |  |  |  |  | [NAME], [NAME]
 | Stumped |  |  |  |  |  |  | Stumped |  |  |  |  |  | Stumped |  |  |  |  |  | Stumped |  |  |  |  |  | Rosmead Sports Complex, Kenilworth
 | Hit Wicket |  |  |  |  |  |  | Hit Wicket |  |  |  |  |  | Hit Wicket |  |  |  |  |  | Hit Wicket |  |  |  |  |  | [NAME], Rondebosch
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sahara Park Newlands
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sarepta Sports Complex, Kuils River
 | Runs scored in boundaries |  |  |  |  |  |  | Runs conceded in boundaries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Silverglades, Fish Hoek
 | Two-Day |  |  |  |  |  |  | Two-Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Ruyterwacht
 | Limited Overs |  |  |  |  |  |  | Limited Overs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Green Point
 | AMA20-20 |  |  |  |  |  |  | AMA20-20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Vineyard, Newlands
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UCT Oval, Groote Schuur
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Western Cape University Oval, Bellville South
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wynberg Boys' High School, Wynberg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wynberg CC, Wynberg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Won by an Innings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Won chasing target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Won defending target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lost by an Innings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lost chasing target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lost defending target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tie
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Result / Abandoned