Thread: conditional sum formula help

I have the following Boolean expression that is not working

if {Cert.Desc_List1} like "PEN*" then {Cert.Amt_List1} or
if {Cert.Desc_List2} like "PEN*" then {Cert.Amt_List2} or
if {Cert.Desc_List3} like "PEN*" then {Cert.Amt_List3} or
if {Cert.Desc_List4} like "PEN*" then {Cert.Amt_List4} or
if {Cert.Desc_List5} like "PEN*" then {Cert.Amt_List5} or
if {Cert.Desc_List6} like "PEN*" then {Cert.Amt_List6} or
if {Cert.Desc_List7} like "PEN*" then {Cert.Amt_List7} or
if {Cert.Desc_List8} like "PEN*" then {Cert.Amt_List8} or

It says I need a Boolean and highlights {Cert.Amt_List7}

I need my formula to do the following...

for all the Desc_List fields that start with "PEN" take the corresponding Amt_List field and total them

Desc_List1 matches Amt_List1, Desc_List2 matches Amt_List2, etc

Can someone help with this formula or tell me a different way to do this?

Thats really uncommon problems. I guess only experts can help you with that. But i know someone that i think can surely help you. Just pm me your email add.