COUNTIFS Formula with multiple criteria including a checkbox

MMWegg

Hello,

I tried multiple formulas and can't seem to figure out to do a count that includes a report code (e.g., OWCA1) and a checkbox. Here is what I have so far:

=COUNTIFS({UHG Risk Control Matrix Range 2}, CONTAINS("OWCA1", @cell), {UHG Risk Control Matrix Range 1}, CONTAINS("1", @cell))

Thank you for any help!!

Michael Culley

To count the checkbox you wouldn't use "CONTAINS" you would just use 1.

So it should be

=COUNTIFS({UHG Risk Control Matrix Range 2}, CONTAINS("OWCA1", @cell), {UHG Risk Control Matrix Range 1}, 1)

*Assuming the {UHG Risk Control Matrix Range 1} is the checkbox column*

MMWegg

Michael,

Thank you so much!! It worked perfectly.

Also, thank you for the quick reply as well!

Michael Culley

To count the checkbox you wouldn't use "CONTAINS" you would just use 1.

So it should be

=COUNTIFS({UHG Risk Control Matrix Range 2}, CONTAINS("OWCA1", @cell), {UHG Risk Control Matrix Range 1}, 1)

*Assuming the {UHG Risk Control Matrix Range 1} is the checkbox column*

MMWegg

Michael,

Thank you so much!! It worked perfectly.

Also, thank you for the quick reply as well!