question about countifs
I'm trying to count the number of checkmarks for departments. Essentially, for this screenshot, the Academy project has people from different departments participating. I want to know how many people from each department are working on it--a count of each. That way, when I add more people to the project, the total counts across departments will increase.
Is there a way to automate this? I've tried countifs, OR, AND, etc, and nothing works. Thank you!
Comments
-
Try this:
=COUNTIFS(Department:Department, "CTWS", Academy:Academy, 1)
=COUNTIFS(Department:Department, "Legal", Academy:Academy, 1)
and so on... one for each column you are using to sum the # of check boxes.
-
nevermind, I figured it out! if anyone is curious:
=COUNTIFS($Academy$1:$Academy$211, 1, $Department$1:$Department$211, $Departments$2)
