Spreadsheet: 274422d1383115476-sum-if-formula-sample
Sheet: data

 | Data
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Products | Regions
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AOL Collections (ST) | Manila ([NAME])
 | Total of Transfer Failure | Months |  |  |  |  |  |  |  |  |  |  |  | Collections (ST) | Manila (Transcom)
 | LOBS | January | February | March | April | May | June | July | August | September | October | Grand Total |  | CS&B (ST)
 | AOL Collections (ST) | 19 | 88 | 25 | 42 | 3 | 3 | 4 | 7 | 12 | 1 | 204 |  | Customer Service Management
 | Manila (Transcom) | 19 | 88 | 25 | 42 | 3 | 3 | 4 | 7 | 12 | 1 | 204 |  | HM 1st Line (ST)
 | Collections (ST) | 80 | 369 | 132 | 284 | 36 | 16 | 32 | 47 | 37 | 19 | 1052 |  | HM Loyalty (ST)
 | Manila (Transcom) | 80 | 369 | 132 | 284 | 36 | 16 | 32 | 47 | 37 | 19 | 1052 |  | Logistic Ops
 | CS&B (ST) | 32 | 93 | 64 | 50 | 46 | 25 | 21 | 9 | 42 | 24 | 406 |  | Onetel Collections
 | Manila (Transcom EDSA) |  | 1 | 1 |  | 2 | 1 |  |  |  |  | 5 |  | Onetel CS&B/Tech
 | Manila (Transcom) | 32 | 92 | 63 | 50 | 44 | 24 | 21 | 9 | 42 | 24 | 401 |  | Other
 | Customer Service Management | 1 | 2 |  | 3 | 2 | 1 | 1 |  |  |  | 10 |  | [NAME] (ST)
 | Manila (Transcom EDSA) |  |  |  |  | 1 |  |  |  |  |  | 1 |  | TalkTalk Plus TV
 | Manila (Transcom) | 1 | 2 |  | 3 | 1 | 1 | 1 |  |  |  | 9 |  | TalkTalk TV
 | HM 1st Line (ST) | 33 | 124 | 57 | 72 | 42 | 47 | 69 | 36 | 41 | 25 | 546 |  | Tech Inbound
 | Manila (Transcom EDSA) |  |  |  |  |  | 6 | 11 | 5 | 12 | 10 | 44 |  | Tech Inbound MBORC
 | Manila (Transcom) | 33 | 124 | 57 | 72 | 42 | 41 | 58 | 31 | 29 | 15 | 502 |  | TT Mobile (ST)
 | HM Loyalty (ST) | 20 | 142 | 77 | 93 | 119 | 68 | 79 | 49 | 28 | 7 | 682 |  | TTB Migration
 | Manila (Transcom) | 20 | 142 | 77 | 93 | 119 | 68 | 79 | 49 | 28 | 7 | 682 |  | TTB SME - Credit Control
 | Logistic Ops | 2 | 12 | 10 | 4 | 3 | 3 | 2 | 2 | 2 |  | 40 |  | TUK Collections (ST)
 | Manila (Transcom) | 2 | 12 | 10 | 4 | 3 | 3 | 2 | 2 | 2 |  | 40 |  | TV Customer Service Management
 | Onetel Collections |  |  | 3 | 1 |  | 2 | 3 | 3 | 4 | 4 | 20 |  | TV Fault Management
 | Manila (Transcom) |  |  | 3 | 1 |  | 2 | 3 | 3 | 4 | 4 | 20 |  | TV FM Escalations
 | Onetel CS&B/Tech | 5 | 16 | 6 | 13 | 5 | 9 | 11 | 12 | 3 |  | 80 |  | TV Self Install
 | Manila (Transcom EDSA) |  |  |  |  |  |  |  | 1 | 1 |  | 2 |  | Unassigned
 | Manila (Transcom) | 5 | 16 | 6 | 13 | 5 | 9 | 11 | 11 | 2 |  | 78
 | Other |  | 1 | 6 | 2 | 1 | 18 | 15 | 4 | 4 | 2 | 53
 | Manila (Transcom) |  | 1 | 6 | 2 | 1 | 18 | 15 | 4 | 4 | 2 | 53
 | [NAME] (ST) |  |  |  |  |  |  |  | 6 | 15 | 14 | 35
 | Manila (Transcom) |  |  |  |  |  |  |  | 6 | 15 | 14 | 35
 | TalkTalk Plus TV | 24 | 111 | 56 | 65 | 81 | 64 | 56 | 60 | 76 | 46 | 639
 | Manila (Transcom EDSA) |  | 10 | 23 | 26 | 36 | 29 | 27 | 29 | 32 | 24 | 236
 | Manila (Transcom) | 24 | 101 | 33 | 39 | 45 | 35 | 29 | 31 | 44 | 22 | 403
 | TalkTalk TV |  | 17 | 9 |  |  |  |  |  |  |  | 26
 | Manila (Transcom) |  | 17 | 9 |  |  |  |  |  |  |  | 26
 | Tech Inbound | 32 | 90 | 45 | 79 | 51 | 26 | 33 | 25 | 26 | 17 | 424
 | Manila (Transcom EDSA) |  | 3 | 9 | 10 | 3 | 1 |  | 4 | 6 |  | 36
 | Manila (Transcom) | 32 | 87 | 36 | 69 | 48 | 25 | 33 | 21 | 20 | 17 | 388
 | Tech Inbound MBORC | 1 | 22 |  |  |  |  |  |  |  |  | 23
 | Manila (Transcom) | 1 | 22 |  |  |  |  |  |  |  |  | 23
 | TT Mobile (ST) | 21 | 105 | 69 | 83 | 107 | 96 | 52 | 56 | 52 | 18 | 659
 | Manila (Transcom EDSA) |  |  |  |  |  | 13 | 23 | 33 | 12 | 3 | 84
 | Manila (Transcom) | 21 | 105 | 69 | 83 | 107 | 83 | 29 | 23 | 40 | 15 | 575
 | TTB Migration |  |  |  |  |  |  | 1 |  |  |  | 1
 | Manila (Transcom) |  |  |  |  |  |  | 1 |  |  |  | 1
 | TTB SME - Credit Control |  |  |  |  | 2 | 5 | 1 | 1 | 1 | 1 | 11
 | Manila (Transcom) |  |  |  |  | 2 | 5 | 1 | 1 | 1 | 1 | 11
 | TUK Collections (ST) | 17 | 59 | 5 |  |  |  |  |  |  |  | 81
 | Manila (Transcom) | 17 | 59 | 5 |  |  |  |  |  |  |  | 81
 | TV Customer Service Management |  |  |  |  | 1 | 2 |  | 2 | 1 |  | 6
 | Manila (Transcom EDSA) |  |  |  |  |  | 2 |  | 2 | 1 |  | 5
 | Manila (Transcom) |  |  |  |  | 1 |  |  |  |  |  | 1
 | TV Fault Management |  |  |  |  |  | 1 |  |  | 1 | 2 | 4
 | Manila (Transcom) |  |  |  |  |  | 1 |  |  | 1 | 2 | 4
 | TV FM Escalations |  |  |  |  | 1 | 4 | 5 |  |  |  | 10
 | Manila (Transcom) |  |  |  |  | 1 | 4 | 5 |  |  |  | 10
 | TV Self Install |  | 10 | 8 | 20 | 15 |  |  |  |  |  | 53
 | Manila (Transcom EDSA) |  |  | 1 | 6 | 6 |  |  |  |  |  | 13
 | Manila (Transcom) |  | 10 | 7 | 14 | 9 |  |  |  |  |  | 40
 | Unassigned | 89 | 256 | 26 |  |  |  |  |  |  |  | 371
 | Manila (Transcom) | 89 | 256 | 26 |  |  |  |  |  |  |  | 371
 | Grand Total | 376 | 1517 | 598 | 811 | 515 | 390 | 385 | 319 | 345 | 180 | 5436