generate a formula

Occasional Visitor

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

 

CompanyCommission TypeWriting Agent NumberWriting Agent NameClientPolicy NumberCommission CategoryCommissionable PremiumCommission AmountModeRepl Pol Eff Date
ACCCommission OverrideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Initial56.20Monthly 
ACCCommission OverrideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Initial0.180Monthly 
ACCCommission OverrideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Initial0.180Monthly 
ACCCommission OverrideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Initial0.180Monthly 
ACCCommission OverrideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Initial9.960Monthly 
ACCCommission OverrideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Initial56.190Monthly 
ACCCommission OverrideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Initial0.180Monthly 
ACCCommission OverrideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Initial0.180Monthly 
ACCCommission OverrideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Initial9.950Monthly 
ACCCommission OverrideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Initial0.180Monthly 
ACCAdvance Commission OverideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Advance2.160.6Annually 
ACCAdvance Commission OverideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Advance2.160.6Annually 
ACCAdvance Commission OverideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Advance674.4188.88Annually 
ACCAdvance Commission OverideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Advance119.5233.48Annually 
ACCAdvance Commission OverideGNW0032842PAUL MLASKOJAMES KICHAKACC2001533Advance2.160.6Annually 
ACCAdvance Commission OverideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Advance2.160.6Annually 
ACCAdvance Commission OverideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Advance119.5233.48Annually 
ACCAdvance Commission OverideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Advance674.4188.88Annually 
ACCAdvance Commission OverideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Advance2.160.6Annually 
ACCAdvance Commission OverideGNW2018338KENDRA WILLIAMSJAMES KICHAKACC2001533Advance2.160.6Annually 
0 Replies