COUNTIFS a range with multiple assigned groups

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

Find more posts tagged with

Formulas

Support

Project Management

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.