CountIF Formula Help for Dashboard
See screenshot. I want to create a graph on a dashboard that shows how many total rows on the sheet pertain to Medical, Fire, and/or Police (indicated by checkbox columns on each row). Will I need to create an Agency Name sub row for each Medical, Fire, and/or Police I want to be represented on the graph for the COUNTIF formula to work? How can I accomplish this? I've also played with using the Discipline column as a multi-select for the COUNTIF formula to use, but to no avail. Help?
Help Article Resources
Check out the Formula Handbook template!