Hello all,
I am trying to COUNTIF a range that includes multiple assigned groups in some cells. I would like to count rows that include "Dept 1". There is one row in particular that contains two assigned groups - "Dept 1" and "Dept 2" - that is not being counted This is my formula:
=COUNTIF({Sheet Range 4 - Department}, "Dept 1")
Any help would be appreciated. Thanks!!!