Spreadsheet: 818264d1676679325-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test2
Sheet: CLAIM MANAGEMENT 2022FY

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custo de venda final ( valor CWFS)
 | Claim Category |  |  |  |  |  |  |  |  |  |  |  |  | Source |  |  |  |  |  |  |  |  |  |  | CLAIM COSTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material + CPO | Penalties | Rework | QAS | Transport | TOTAL
 | C |  |  |  |  |  |  |  |  |  |  |  |  | Sales advicing |  |  |  |  |  |  |  |  |  |  | 4880
APR | A |  |  |  |  |  |  |  |  |  |  |  |  | Production not TFM |  |  |  |  |  |  |  |  |  |  | 6.09 |  |  | 12.94
 | Eliminada |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 167 |  |  | 12.94 | 6.7
 | A |  |  |  |  |  |  |  |  |  |  |  |  | Production not TFM
 | Not accepted - Dispatch |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  | 12.05 |  |  | 12.94 | 6.7 |  |  |  |  |  |  | 6,7 - Transporte
MAY | NA |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  | 189.63 |  |  | 12.94 | 12.94
 | Eliminada
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Em avaliação
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  | 663 |  |  | 12.94 | 6.7 | 695.2
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  | 14 |  |  | 12.94 | 6.7
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94 | 6.7
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Sales (salesman) |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94 | 6.7
 | NA |  |  |  |  |  |  |  |  |  |  |  |  | Gloma |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94
JUN | B |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted TFM - Production YKK PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch not TFM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Unclear - Other processes [NAME] PT |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 |  |  |  |  |  |  |  |  |  |  |  |  |  | YKK Spain
 | A |  |  |  |  |  |  |  |  |  |  |  |  | Production not TFM |  |  |  |  |  |  |  |  |  |  | 727 |  |  |  | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Unclear - Other processes [NAME] PT
 | Inquiry |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
JUL |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 6.7
 | Eliminada
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  | Stock zippers
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Unclear - Other processes [NAME] PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales (salesman) |  |  |  |  |  |  |  |  |  |  |  |  | 204 |  | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DPD
AUG |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch not TFM |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94 | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | YM
SEP |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.94
 | Eliminada
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 12.9
 | Eliminada
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WUXI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DPD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch not TFM |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.9 | 6.7
OCT | [NAME] ([NAME])
 | Eliminada |  |  |  |  |  |  |  |  |  |  |  |  | DPD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.88 | 6.7
 | B |  |  |  |  |  |  |  |  |  |  |  |  | Unclear - Production YKK PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | A |  |  |  |  |  |  |  |  |  |  |  |  | Production not TFM |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 6.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch not TFM |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.88 | 13.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WUXI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 12.9 | 6.7
NOV |  |  |  |  |  |  |  |  |  |  |  |  |  | Art in Vogue
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WUXI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WUXI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 | E |  |  |  |  |  |  |  |  |  |  |  |  | Unclear - Production YKK PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WUXI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Service (delivery date)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Service (delivery date)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted TFM - Production YKK PT
 | B |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch not TFM
 | B |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted  Production YKK PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
DEC |  |  |  |  |  |  |  |  |  |  |  |  |  | Unfounded ( [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Service (delivery date) YKK Italy
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | E |  |  |  |  |  |  |  |  |  |  |  |  | Unclear - Production YKK PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales
 | Eliminada
 | B |  |  |  |  |  |  |  |  |  |  |  |  | Not accepted - Others
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WUXI
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Unclear - Production YKK PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Production not TFM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch not TFM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | YM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.44