COUNTIFS a range with multiple assigned groups

pixel_

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!!!

Paul Newcome

Try using a FIND function for your criteria

 

=COUNTIF({Sheet Range 4 - Department}, FIND("Dept 1", @cell) > 0)

pixel_

That did the trick. Thank you so much, Paul!

Paul Newcome

Happy to help!