Spreadsheet: 731882d1620655855-sumifs-problem-merged-cells-claims-recap-marie-1
Sheet: H&M

Vsl name | insured | Claim type | Policy cover | Policy nr | Policy Leader | Policy beginning | End Policy | Claim Description | Incident date | Claim rcvd date | Currency | Claimed | Agreed | Deductible | Beneficiary | Amount | paid date | Insurer | Reference | Part | To be received | Received | [NAME] date | Notes | Status
AAAAAA |  | Collision | H&M |  |  | 2020-10-01 00:00:00 |  | [NAME] collision to SYA at anchor [NAME] | 2021-03-28 00:00:00 | 2021-05-04 00:00:00 | EUR | 4000 |  |  | Marine Expert |  |  | [NAME] |  | 0.52 |  |  |  |  | 29/03/21 - notif of incident fm capain rcvd and passed to Ins 04/05/21 - Insp report rcvd Aw insp inv tb reinv to insurers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aquilano |  | 0.175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swiss Re |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NHC |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Satec |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helvetia |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALLIANZ |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Siat |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AXA |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  | 50000 |  | 1000000 | VALLA YACHTS LIMITED |  |  | [NAME] |  | 0.52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aquilano |  | 0.175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swiss Re |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NHC |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Satec |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helvetia |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALLIANZ |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Siat |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AXA |  | 0.025
AAAAAAAAAAA |  | Vibration | H&M |  |  | 2020-10-01 00:00:00 |  | Mats vibration | 2021-04-13 00:00:00 | 2021-05-04 00:00:00 | EUR | 4000 |  |  | Marine Expert |  |  | [NAME] |  | 0.52 |  |  |  |  | 20/04/21 - notif of incident fm capain rcvd and passed to Ins ([NAME]) 04/05/21 - Insp report rcvd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aquilano |  | 0.175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swiss Re |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NHC |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Satec |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helvetia |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALLIANZ |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Siat |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AXA |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  | 1600000 |  | 1000000 | VALLA YACHTS LIMITED | 600000 |  | [NAME] |  | 0.52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aquilano |  | 0.175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swiss Re |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NHC |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Satec |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helvetia |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALLIANZ |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Siat |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AXA |  | 0.025
BBBBBBBBBBB |  | Hull damages | H&M |  |  | 2019-11-25 00:00:00 | 2020-11-25 00:00:00 | [NAME] damages | 2020-10-03 00:00:00 | 2020-10-19 00:00:00 | USD | 2000 |  |  | Smarcity Malta |  |  | [NAME] |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 51357.75 |  | 30000
BBBBBBBBBBB |  | Hull damages | H&M |  |  | 2020-11-25 00:00:00 | 2021-11-25 00:00:00 | [NAME] damages | 2020-12-28 00:00:00 | 2020-10-19 00:00:00 | EUR | 2000 |  |  | Smarcity Malta |  |  | [NAME] |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 51357.75 |  | 50000
[NAME] |  | Hull damages | H&M |  |  |  |  |  |  |  | USD | 2000000 | 2000000 | 1000000 |  |  |  | Helvetia |  | 1
dddd |  | Hull damages | H&M |  |  |  |  |  |  |  | EUR | 115000 |  | 70000 |  |  |  | [NAME] |  | 0.52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aquilano |  | 0.36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0.12