# How would I modify this code to work?tells me in the first part i have to many arguements for this function. "*11*","*15*", etc.

IF(
AND(COUNTIF(\$AP2,"*11*","*15*","*17*","*20*","*49*","*50*", "*71*", "*72*"                                                                                                                                                                                                                                                                                                                                                                                                   ),SUM(COUNTIF(\$AV2:\$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"                                                                                                                                                                                                  }))>0),"Unable to resolve. Need InfoCode for LABOUTP. BMSD is mapped. Benefit Engine not mapped.",

How would I modify this code to work?tells me in the first part i have to many arguements for this function. "*11*","*15*", etc. I need it to work for everything listed above.

Thank you..
###### Who is Participating?

x

Excel VBA DeveloperCommented:
Try this:
=IF(AND(SUM(COUNTIF(\$AP2,{"*11*","*15*","*17*","*20*","*49*","*50*","*71*","*72*"}))>0,SUM(COUNTIF(\$AV2:\$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"}))>0),"Unable to resolve. Need InfoCode for LABOUTP. BMSD is mapped. Benefit Engine not mapped.","Please Review")

You had an extra close paranthesis after the ">0" test.
0

Excel VBA DeveloperCommented:
Can you please re-type your formula exactly as it appears in your workbook?  The original post has it split up in a way that doesn't make sense.  There are no [value if true] or [value if false] arguments in your IF statement.  You're also missing a closing } in your initial COUNTIF list.

Perhaps this will work:
=IF(AND(SUM(COUNTIF(\$AP2,{"*11*","*15*","*17*","*20*","*49*","*50*","*71*","*72*"}))>0,SUM(COUNTIF(\$AV2:\$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"}))>0),TRUE,FALSE)

replacing TRUE, FALSE with your intended actions.

-Glenn
0

Data AnalystAuthor Commented:
Hi Glenn,

This is what the formula would look like.

=IF(AND(SUM(COUNTIF(\$AP2,{"*11*","*15*","*17*","*20*","*49*","*50*", "*71*", "*72*"}))>0),SUM(COUNTIF(\$AV2:\$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"}))>0),"Unable to resolve. Need InfoCode for LABOUTP. BMSD is mapped. Benefit Engine not mapped.","Please Review")

not working.
0

Data AnalystAuthor Commented:
Perfect.....  thank you Glenn for the speedy solution working perfectly.
0

Excel VBA DeveloperCommented:
You're welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.