Question

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 · Accepted Answer

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 · Accepted Answer

Michael,

Thank you so much!! It worked perfectly.

Also, thank you for the quick reply as well!