Mar 13 2022 09:12 PM
i need a formula for sum based on multiple criteria. i need total of all the premium amounts and all comm. amounts for POLICY ACC29915330 -INITIAL
ssame way i need total of all Premium amounts and comm amount for Policy ACC29915330-ADVANCE
Company | Commission Type | Writing Agent Number | Writing Agent Name | Client | Policy Number | Commission Category | Commissionable Premium | Commission Amount | Mode | Repl Pol Eff Date |
ACC | Commission Override | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Initial | 56.2 | 0 | Monthly | |
ACC | Commission Override | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Initial | 0.18 | 0 | Monthly | |
ACC | Commission Override | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Initial | 0.18 | 0 | Monthly | |
ACC | Commission Override | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Initial | 0.18 | 0 | Monthly | |
ACC | Commission Override | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Initial | 9.96 | 0 | Monthly | |
ACC | Commission Override | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Initial | 56.19 | 0 | Monthly | |
ACC | Commission Override | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Initial | 0.18 | 0 | Monthly | |
ACC | Commission Override | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Initial | 0.18 | 0 | Monthly | |
ACC | Commission Override | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Initial | 9.95 | 0 | Monthly | |
ACC | Commission Override | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Initial | 0.18 | 0 | Monthly | |
ACC | Advance Commission Overide | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Advance | 2.16 | 0.6 | Annually | |
ACC | Advance Commission Overide | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Advance | 2.16 | 0.6 | Annually | |
ACC | Advance Commission Overide | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Advance | 674.4 | 188.88 | Annually | |
ACC | Advance Commission Overide | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Advance | 119.52 | 33.48 | Annually | |
ACC | Advance Commission Overide | GNW0032842 | PAUL MLASKO | JAMES KICHAK | ACC2001533 | Advance | 2.16 | 0.6 | Annually | |
ACC | Advance Commission Overide | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Advance | 2.16 | 0.6 | Annually | |
ACC | Advance Commission Overide | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Advance | 119.52 | 33.48 | Annually | |
ACC | Advance Commission Overide | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Advance | 674.4 | 188.88 | Annually | |
ACC | Advance Commission Overide | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Advance | 2.16 | 0.6 | Annually | |
ACC | Advance Commission Overide | GNW2018338 | KENDRA WILLIAMS | JAMES KICHAK | ACC2001533 | Advance | 2.16 | 0.6 | Annually |