COUNTIFS a range with multiple assigned groups

pixel_ ✭✭
edited 12/09/19 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!