I have 2 columns i'm trying to count information one is drop down where I need to count rows where a checkbox is checked. I have the formula to find the locations in the columns which works by itself. However; I'm having trouble how to add to count the rows where a checkbox is checked that has either of the location listed in the drop down. The check box column is called "physician leadership" this is for a sheet summary. how do i add additional formula(and what is it) to get the formula to count the checked boxes.
=COUNTIF(Location:Location, OR(CONTAINS("Brock", @cell), CONTAINS("Princess Anne", @cell)))
i've tried to use AND(physician leadership: physician leadership,1) but keep getting error.
Help Article Resources
Check out the Formula Handbook template!