Hello, there. I am working on creating a data collection template for my colleagues and I am struggling to figure out the right formula to count what I need. I am trying to find out the number of unique police precincts that have at least 1 operational intervention site. So, Column C has Police precincts (some are repeated since multiple police sites can be within one precinct). Column E lists if it is operational MPP site, Column G lists if it is an operational PBS site and column L lists if it an operational PSM site. I need excel to look through column C and first identify only unique precincts, then look through those rows for "operational" in AT least one of the 3 columns (E,G,L) without double counting, and produce a count of all the precincts that meet the criteria.
I've attached a picture of the data table.
Any help on this would be so appreciated!
Bookmarks