Spreadsheet: 119574d1314580845-extract-and-sum-numbers-from-a-text-string-example
Sheet: 2012

2012       RED-PUB HOL    GREEN-A/L & W/L    BLUE-S/L   PURPLE -C/L   YELLOW-WKEND
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y | 0 | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y | 0 | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
 | PUB |  |  | SL-Y |  | CL-Y |  | TOT-Y |  | SL-N |  |  | TOT  P/L |  |  |  |  |  | LSL |  | A/L
JANUARY
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  | CLY-7.5 | SLY-7.0 | CLY-2.0 |  |  | CLY-5.0 |  |  | LSL-4.2 | A/L-4.5
FEBRUARY
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
[NAME]
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
APRIL
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
MAY
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME]
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
JULY
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
AUGUST
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
SEPTEMBER
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
OCTOBER
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
NOVEMBER
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
DECEMBER
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31