COUNTIF, CHECKBOX with CONTAINS BRANCH "MIL"
Hello, Please help and thanks in advance.
I am trying to Count all the KeyUser cells with a checkbox where the branch is MIL. I have tried the below formula but keep getting #UNPARSEABLE.
Formula I tried is =COUNTIF([KeyUser]:[KeyUser], =1), CONTAINS ("MIL",@cell,[Branch;Branch])
Also tried =COUNTIF([KeyUser]:[KeyUser], =1),CONTAINS ("MIL",[Branch:Branch])
Also tried =COUNTIF(KeyUser:[KeyUser],=1), CONTAINS("MIL",@cell, Branch:Branch)
I am able to get it to count the checkboxes but cannot get it to do the AND CONTAINS.
"Help Me ObiWan, you're my only hope."
Thanks much if you can help.
J
Best Answer

Oh no J,
So close but it’s the first part that is probably causing the problem. Try COUTIFS instead of COUNTIF. That will allow for the 2 criteria. Move the closing parentheses after the =1 to the very end. Then play around with the contains part. Is that a multiselect list? If it isn’t Branch:Branch=“MIL” will suffice.
=COUNTIFS([KeyUser]:[KeyUser], 1,Branch:Branch],”MIL”)
Answers

Oh no J,
So close but it’s the first part that is probably causing the problem. Try COUTIFS instead of COUNTIF. That will allow for the 2 criteria. Move the closing parentheses after the =1 to the very end. Then play around with the contains part. Is that a multiselect list? If it isn’t Branch:Branch=“MIL” will suffice.
=COUNTIFS([KeyUser]:[KeyUser], 1,Branch:Branch],”MIL”)

Thanks KPH, That worked perfectly on the first pass. Much appreciated.
Help Article Resources
Categories
Check out the Formula Handbook template!