Spreadsheet: 96174d1295589962-summing-data-with-criteria-into-one-total-summing-data-wth-criterions
Sheet: Clients Data

Row No | Age At Entry | NAME OF THE POLICY HOLDER | UNIQUE DATES | Date of Comm Month | POLICY NO | Date of  Comm | T-T | [NAME] | PREMIUM | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED |  |  |  | Current Pay-By Date |  |  |  |  |  |  |  | Clients Data | Clients Data |  |  | Criterions
Row 2 | 23 | Shailesh Pradhan | 1 | 12 | 306595933 | 2003-12-14 00:00:00 | 48-25 | 15 | 4988 | [NAME] | LIMITED PYMNT WITH PROFITS | Insurance | 100000 |  |  |  | 2011-12-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1 |  | FILENAME | Clients Data
Row 3 | 23 | Shailesh Pradhan | 2 | 6 | 302393596 | 2004-06-28 00:00:00 | 14-30 | 30 | 1803 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-06-28 00:00:00 |  |  |  |  |  |  |  |  |  | 0 |  | NAME OF THE POLICY HOLDER | Shailesh Pradhan
Row 4 | 23 | Shailesh Pradhan |  | 6 | 302393595 | 2004-06-28 00:00:00 | 14-31 | 31 | 1753 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | MODE | [NAME]
Row 5 | 23 | Shailesh Pradhan |  | 6 | 302393598 | 2004-06-28 00:00:00 | 14-32 | 32 | 1705 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | PREMIUM | 1000
Row 6 | 24 | Shailesh Pradhan | 3 | 2 | 302553663 | 2005-02-15 00:00:00 | 169-22 | 22 | 10198 | [NAME] | JEEVAN NIDHI WITH GUAR ADDTNS | Pension | 220000 |  |  |  | 2011-02-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | SUM ASSURED | 50000
Row 7 | 24 | Shailesh Pradhan |  | 2 | 302553669 | 2005-02-15 00:00:00 | 14-32 | 32 | 1705 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-02-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | PLAN  TYPE | ULIP+Risk
Row 8 | 24 | Shailesh Pradhan |  | 2 | 302553665 | 2005-02-15 00:00:00 | 14-33 | 33 | 1659 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-02-15 00:00:00
Row 9 | 24 | Shailesh Pradhan |  | 2 | 302553666 | 2005-02-15 00:00:00 | 14-34 | 34 | 1619 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-02-15 00:00:00
Row 10 | 25 | Shailesh Pradhan | 4 | 7 | 302695295 | 2005-07-20 00:00:00 | 150-30 | 30 | 3119 | [NAME] | NEW BIMA KIRAN | Insurance | 300000 |  |  |  | 2011-07-20 00:00:00
Row 11 | 25 | Shailesh Pradhan |  | 7 | 302695296 | 2005-07-20 00:00:00 | 14-35 | 35 | 1600 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 |  |  |  | 2011-07-20 00:00:00
Row 12 | 25 | Shailesh Pradhan |  | 6 | 302565869 | 2006-06-21 00:00:00 | 173-70 | 70 | 5000 | [NAME] | JEEVAN PLUS | ULIP+Risk | 50000 |  |  |  | 2011-06-21 00:00:00
Row 13 | 25 | Shailesh Pradhan |  | 6 | 302565865 | 2006-06-21 00:00:00 | 172-21 | 21 | 5000 | [NAME] | FUTURE PLUS | ULIP | 50000 |  |  |  | 2011-06-21 00:00:00
Row 14 | 26 | Shailesh Pradhan |  |  | 302565680 | 2006-08-21 00:00:00 | 181-10 | 1 | 10000 | SGL | MARKET PLUS | ULIP | 0 |  |  |  | 2011-08-21 00:00:00
Row 15 | 27 | Shailesh Pradhan |  |  | 303632855 | 2008-06-27 00:00:00 | 165-35 | 35 | 1021 | ECS | JEEVAN SARAL | Insurance | 250000 |  |  |  | 2011-06-27 00:00:00
Row 16 | 11 | Sachin Deshpande |  | 2 | 320082350 | 1989-02-15 00:00:00 | 93-25 | 25 | 10896 | [NAME] | MONEY BACK | ULIP+Risk | 200000 |  |  |  | 2011-02-15 00:00:00
Row 17 | 24 | Sachin Deshpande |  |  | 306595305 | 2002-09-16 00:00:00 | 142-10 | 1 | 102507 | SGL | NEW BIMA NIVESH (SINGLE PREM) | Insurance | 120000 |  |  |  | 2011-09-16 00:00:00 |  |  |  |  |  |  |  |  |  | 55000
Row 18 | 28 | Sachin Deshpande |  | 6 | 302565866 | 2006-06-21 00:00:00 | 172-10 | 10 | 5000 | [NAME] | FUTURE PLUS | ULIP | 0 |  |  |  | 2011-06-21 00:00:00 |  |  |  |  |  |  |  |  | COUNTIF | 7
Row 19 | 28 | Sachin Deshpande |  |  | 302565652 | 2006-08-21 00:00:00 | 181-10 | 1 | 10000 | SGL | MARKET PLUS | ULIP | 0 |  |  |  | 2011-08-21 00:00:00
Row 20 | 28 | Sachin Deshpande |  |  | 303632869 | 2006-06-27 00:00:00 | 191-10 | 1 | 10000 | SGL | MARKET PLUS - I | ULIP | 0 |  |  |  | 2011-06-27 00:00:00
Row 21 | 27 | Manisha Naik |  | 7 | 306595932 | 2002-07-25 00:00:00 | 14-26 | 26 | 3586 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 100000 |  |  |  | 2011-07-25 00:00:00
Row 22 | 27 | Manisha Naik |  | 7 | 306595633 | 2002-07-25 00:00:00 | 93-25 | 25 | 5060 | [NAME] | MONEY BACK | Insurance | 100000 |  |  |  | 2011-07-25 00:00:00
Row 23 | 30 | Manisha Naik |  | 6 | 302699658 | 2005-06-28 00:00:00 | 149-21 | 21 | 5131 | [NAME] | [NAME] | Insurance | 100000 |  |  |  | 2011-06-28 00:00:00
Row 24 | 31 | Manisha Naik |  | 6 | 302565865 | 2006-06-21 00:00:00 | 172-21 | 25 | 5000 | [NAME] | FUTURE PLUS | ULIP | 0 |  |  |  | 2011-06-21 00:00:00
Row 25 | 31 | Manisha Naik |  | 6 | 302565868 | 2006-06-21 00:00:00 | 173-76 | 76 | 5000 | [NAME] | JEEVAN PLUS | ULIP+Risk | 50000 |  |  |  | 2011-06-21 00:00:00
Row 26 | 33 | Manisha Naik |  |  | 303632336 | 2008-06-28 00:00:00 | 165-35 | 35 | 1021 | ECS | JEEVAN SARAL | Insurance | 250000 |  |  |  | 2011-06-28 00:00:00