Spreadsheet: 44058d1242734081-sum-product-help-sumproducthelp1
Sheet: Sheet1

Product | DOB | TotalLumpSum
ISA | 1949-03-03 00:00:00 | 0
Cash Account | 1949-03-03 00:00:00 | 0
Cash Deposit | 1949-03-03 00:00:00 | 0
Discretionary Managed Service | 1912-06-19 00:00:00 | 56431
Endowment | 1916-08-14 00:00:00 | 83351
Equity Holdings | 1920-10-18 00:00:00 | 30000
Executive Pension Plan | 1920-03-20 00:00:00 | 156343
Final Salary Scheme | 1934-05-16 00:00:00 | 47341
[NAME] | 1940-01-16 00:00:00 | 14000
Group Personal Pension | 1931-07-23 00:00:00 | 0
Guaranteed Growth Bond | 1931-07-23 00:00:00 | 0
Guaranteed Income Bond | 1932-04-24 00:00:00 | 0
Insurance / Investment Bond | 1935-05-28 00:00:00 | 50000
Investment Trust | 1935-05-28 00:00:00 | 28500
ISA | 1935-05-28 00:00:00 | 7200
Long Term Care | 1935-05-28 00:00:00 | 7200
National Savings | 1935-05-28 00:00:00 | 0
OEIC / Unit Trust | 1935-05-28 00:00:00 | 0
Offshore Bond | 1935-05-28 00:00:00 | 0
Offshore OEIC / Fund | 1935-05-28 00:00:00 | 0
Pension Annuity | 1935-05-28 00:00:00 | 0
Pension Term Assurance | 1935-05-28 00:00:00 | 0
Permanent Health Insurance | 1935-05-28 00:00:00 | 0
Personal Equity Plan | 1935-05-28 00:00:00 | 0
Personal Pension Plan | 1935-05-28 00:00:00 | 0
s226 RAC | 1907-10-09 00:00:00 | 100120
s32 [NAME] | 1916-10-21 00:00:00 | 85324
Savings Account | 1925-05-13 00:00:00 | 92972
ISA | 1925-05-13 00:00:00 | 50000
Cash Account | 1925-05-13 00:00:00 | 67926
Cash Deposit | 1925-05-13 00:00:00 | 60000
Discretionary Managed Service | 1925-09-22 00:00:00 | 78760
Endowment | 1923-11-11 00:00:00 | 89515
Equity Holdings | 1919-06-12 00:00:00 | 94212
Executive Pension Plan | 1924-05-06 00:00:00 | 30000
Final Salary Scheme | 1911-02-02 00:00:00 | 77586
[NAME] | 1925-09-13 00:00:00 | 87824
Group Personal Pension | 1935-12-14 00:00:00 | 63363
Guaranteed Growth Bond | 1935-12-14 00:00:00 | 72221
Guaranteed Income Bond | 1935-12-14 00:00:00 | 192000
Insurance / Investment Bond | 1935-12-14 00:00:00 | 124244
Investment Trust | 1935-12-14 00:00:00 | 82700
ISA | 1935-12-14 00:00:00 | 400000
Long Term Care | 1935-12-14 00:00:00 | 48540
National Savings | 1935-12-14 00:00:00 | 31377
OEIC / Unit Trust | 1935-12-14 00:00:00 | 15000
Offshore Bond | 1936-06-20 00:00:00 | 7000
Offshore OEIC / Fund | 1936-06-20 00:00:00 | 91501
Pension Annuity | 1936-06-20 00:00:00 | 0
Pension Term Assurance | 1936-06-20 00:00:00 | 0
Permanent Health Insurance | 1936-06-20 00:00:00 | 0
Personal Equity Plan | 1936-06-20 00:00:00 | 0
Personal Pension Plan | 1936-06-20 00:00:00 | 0
s226 RAC | 1936-06-20 00:00:00 | 81373
s32 [NAME] | 1936-06-20 00:00:00 | 101953
Savings Account | 1936-06-20 00:00:00 | 47511
ISA | 1927-03-29 00:00:00 | 103751
Cash Account | 1923-06-21 00:00:00 | 185000
Cash Deposit | 1916-02-19 00:00:00 | 71800
Discretionary Managed Service | 1923-08-04 00:00:00 | 158681
Endowment | 1923-09-11 00:00:00 | 0
Equity Holdings | 1917-08-22 00:00:00 | 110285
Executive Pension Plan | 1920-10-06 00:00:00 | 7000
Final Salary Scheme | 1913-02-19 00:00:00 | 81268
[NAME] | 1919-05-23 00:00:00 | 0
Group Personal Pension | 1914-01-18 00:00:00 | 0
Guaranteed Growth Bond | 1914-01-18 00:00:00 | 0
Guaranteed Income Bond | 1930-06-04 00:00:00 | 82900
Insurance / Investment Bond | 1922-09-30 00:00:00 | 65582
Investment Trust | 1915-01-03 00:00:00 | 59811
ISA | 1944-11-20 00:00:00 | 129564
Long Term Care | 1944-11-20 00:00:00 | 64816
National Savings | 1944-11-20 00:00:00 | 85102
OEIC / Unit Trust | 1945-06-07 00:00:00 | 165296
Offshore Bond | 1945-06-07 00:00:00 | 20000
Offshore OEIC / Fund | 1921-05-27 00:00:00 | 20000
Pension Annuity | 1921-05-27 00:00:00 | 19000
Pension Term Assurance | 1911-09-07 00:00:00 | 19000
Permanent Health Insurance | 1911-09-07 00:00:00 | 11830
Personal Equity Plan | 1917-11-11 00:00:00 | 11600
Personal Pension Plan | 1915-08-31 00:00:00 | 3600
s226 RAC | 1916-05-01 00:00:00 | 0
s32 [NAME] | 1920-02-06 00:00:00 | 165296
Savings Account | 1920-05-13 00:00:00 | 20000
Pension Term Assurance | 1931-08-17 00:00:00 | 20000
Permanent Health Insurance | 1928-05-10 00:00:00 | 11600
Personal Equity Plan | 1920-01-20 00:00:00 | 7200
Personal Pension Plan | 1913-05-13 00:00:00 | 7200
s226 RAC | 1935-09-04 00:00:00 | 3000
s32 [NAME] | 1924-05-18 00:00:00 | 0
Savings Account | 1923-02-26 00:00:00 | 0
Pension Term Assurance | 1919-05-16 00:00:00 | 0
Permanent Health Insurance | 1919-05-16 00:00:00 | 130733
Personal Equity Plan | 1918-11-19 00:00:00 | 96100
Personal Pension Plan | 1919-08-28 00:00:00 | 260000
s226 RAC | 1920-01-31 00:00:00 | 1
s32 [NAME] | 1923-10-30 00:00:00 | 30661
Savings Account | 1928-05-11 00:00:00 | 61849
Pension Term Assurance | 1942-10-19 00:00:00 | 39381
Permanent Health Insurance | 1942-10-19 00:00:00 | 30190
Personal Equity Plan | 1942-10-19 00:00:00 | 103468
Personal Pension Plan | 1942-10-19 00:00:00 | 45643
s226 RAC | 1942-10-19 00:00:00 | 14000
s32 [NAME] | 1958-07-15 00:00:00 | 100000
Savings Account | 1942-06-12 00:00:00 | 70118
Endowment | 1942-06-12 00:00:00 | 46480
Equity Holdings | 1942-06-12 00:00:00 | 47640
Executive Pension Plan | 1921-04-01 00:00:00 | 4000
Final Salary Scheme | 1933-08-03 00:00:00 | 0
[NAME] | 1933-08-03 00:00:00 | 47640
Group Personal Pension | 1933-08-03 00:00:00 | 4000
Guaranteed Growth Bond | 1935-09-18 00:00:00 | 100000
Guaranteed Income Bond | 1935-09-18 00:00:00 | 39342