COUNTIFS Formula with multiple criteria including a checkbox
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!!
Best Answers

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*

Michael,
Thank you so much!! It worked perfectly.
Also, thank you for the quick reply as well!
Answers

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*

Michael,
Thank you so much!! It worked perfectly.
Also, thank you for the quick reply as well!
Help Article Resources
Categories
Check out the Formula Handbook template!