COUNTIFS: Column Contains, Column with Checkbox

Mary Ayers · 02/09/21

Hello formula experts,

I am trying to return a count of instances where the [Implemented] cell is checked and the [Goal Category] cell contains "Environment" as one of the choices.

This formula is returning #INVALID OPERATION

=COUNTIFS(Implemented:Implemented, 1, [Goal Category]:[Goal Category], CONTAINS("Environment"))

Thanks in advance for your help!

Mary

Andrée Starå · 02/10/21

Hi @Mary Ayers

I hope you're well and safe!

Try something like this.

=COUNTIFS(Implemented:Implemented; 1; [Goal Category]:[Goal Category]; CONTAINS("Environment"; @cell))

Depending on your country/region, you'll need to exchange the comma to a period.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil · 02/10/21

Hi @Mary Ayers

Hope you are fine, try to use the following formula

=COUNTIFS(Implemented:Implemented, 1, [Goal Category]:[Goal Category], CONTAINS("Environment", @cell))

Mary Ayers · 02/10/21

Thank you to both Andrée and Bassam!

Cheers!

Mary

Andrée Starå · 02/10/21

Hi @Mary Ayers

I hope you're well and safe!

Try something like this.

=COUNTIFS(Implemented:Implemented; 1; [Goal Category]:[Goal Category]; CONTAINS("Environment"; @cell))

Depending on your country/region, you'll need to exchange the comma to a period.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!