Spreadsheet: 849923d1700285287-dsum-formula-help-excel-page-clients
Sheet: Clients

CTC Casualty Insurance |  |  |  |  |  |  |  | Premiums
Client ID | Client | Start Date | Policy Number | Policy Type | Bundled? | Per Month | Payment |  | Client ID | VA2118
CU2107 | Addison Cushman | 2024-06-07 00:00:00 | 14-586 | Auto | No | 98 |  |  | Client name
RE2109 | [NAME] | 2024-09-03 00:00:00 | 18-672 | Auto | Yes | 52 |  |  | Policy Type
PA1733 | [NAME] | 2024-08-16 00:00:00 | 20-560 | Classic car | No | 49
BR2215 | [NAME] | 2024-02-05 00:00:00 | 19-456 | Auto | No | 95 |  |  | Payments
RE1165 | [NAME] | 2024-12-09 00:00:00 | 14-098 | Motorcycle | No | 101 |  |  | Policies
SP1378 | Clare Ann Spahn | 2024-05-15 00:00:00 | 14-238 | Auto | No | 22 |  |  | Policy Type
VO2023 | Cliff Voltz | 2024-04-02 00:00:00 | 16-214 | Auto | Yes | 53 |  |  | Auto
WI1992 | Danielle [NAME] | 2024-05-08 00:00:00 | 14-587 | RV/Trailer | Yes | 81 |  |  | Classic car
YO1522 | [NAME] | 2024-09-05 00:00:00 | 18-673 | Auto | No | 53 |  |  | Motorcycle
MA2177 | [NAME] | 2024-11-06 00:00:00 | 20-561 | Auto | Yes | 96 |  |  | RV/Trailer
CH1643 | [NAME] | 2024-06-12 00:00:00 | 19-457 | Auto | No | 87
GU2732 | [NAME] | 2024-10-18 00:00:00 | 14-378 | Motorcycle | No | 72
ST1488 | [NAME] | 2024-04-07 00:00:00 | 14-518 | Auto | No | 49
MO1596 | Felipe Morales | 2024-01-30 00:00:00 | 14-587 | Auto | No | 50
CO2341 | [NAME] | 2024-03-31 00:00:00 | 18-673 | Auto | Yes | 94
TA1334 | [NAME] | 2024-08-19 00:00:00 | 20-561 | Auto | No | 79
GU1082 | [NAME] | 2024-11-09 00:00:00 | 19-457 | Auto | Yes | 51
CH1525 | [NAME] | 2024-10-19 00:00:00 | 14-378 | Motorcycle | No | 73
SH2109 | [NAME] | 2024-07-28 00:00:00 | 14-518 | Classic car | No | 84
AT2317 | [NAME] | 2024-01-16 00:00:00 | 16-215 | Auto | Yes | 96
BR1966 | [NAME] | 2024-05-20 00:00:00 | 14-588 | Auto | No | 98
WU2304 | Kendall Wu | 2024-11-30 00:00:00 | 18-674 | RV/Trailer | No | 99
JA1983 | [NAME] | 2024-07-15 00:00:00 | 20-562 | Auto | No | 44
KO1743 | [NAME] | 2024-12-20 00:00:00 | 19-458 | Auto | Yes | 41
HU2087 | [NAME] | 2024-09-03 00:00:00 | 14-658 | Auto | Yes | 52
CO2037 | [NAME] | 2024-10-03 00:00:00 | 14-587 | Motorcycle | No | 72
KA1969 | [NAME] | 2024-03-22 00:00:00 | 18-673 | Auto | Yes | 41
HE2081 | [NAME] | 2024-04-20 00:00:00 | 20-561 | Auto | Yes | 42
MA1696 | [NAME] | 2024-01-25 00:00:00 | 19-457 | Auto | Yes | 43
RA1380 | [NAME] | 2024-02-06 00:00:00 | 14-378 | Auto | No | 47
LI1482 | [NAME] | 2024-08-30 00:00:00 | 14-518 | Motorcycle | Yes | 69
TH2331 | [NAME] | 2024-11-04 00:00:00 | 16-215 | Auto | Yes | 44
TH1927 | [NAME] | 2024-09-03 00:00:00 | 14-588 | Auto | No | 52
KA1767 | [NAME] | 2024-10-03 00:00:00 | 18-674 | Auto | No | 51
VA2118 | [NAME] | 2024-03-22 00:00:00 | 14-587 | Auto | No | 44
CH2201 | [NAME] | 2024-04-20 00:00:00 | 18-673 | Classic car | Yes | 75
JO2337 | [NAME] | 2024-01-25 00:00:00 | 20-561 | Auto | No | 52
WA1336 | [NAME] | 2024-02-06 00:00:00 | 19-457 | Auto | Yes | 53
IV1868 | Shaniqua Ivers | 2024-08-30 00:00:00 | 14-378 | Auto | Yes | 98
[NAME] | [NAME] | 2024-09-03 00:00:00 | 14-518 | Auto | Yes | 56
BU2245 | Tamara Burroughs | 2024-10-03 00:00:00 | 16-215 | Auto | No | 47
GR2376 | [NAME] | 2024-03-22 00:00:00 | 14-588 | Motorcycle | Yes | 80
WA1873 | [NAME] | 2024-04-20 00:00:00 | 18-674 | Classic car | No | 74
EN1875 | Troy Enderes | 2024-01-25 00:00:00 | 20-562 | Auto | Yes | 55
KH2025 | [NAME] | 2024-02-06 00:00:00 | 19-458 | Auto | No | 53
Total