Hello all,
I am trying to count rows for one department. This department also has sub-departments. In some rows, it has multiple sub-departments assigned to it.
This is my formula:
=COUNTIFS({Requests Range 2 - Status}, Category2, {Requests Range 4 - Department}, (FIND("Merchandising", @cell) > 0))
For example, one row has "Merchandising-Sales" and "Merchandising-Accounting" assigned to it. I want to count this row once, but the current formula is counting is twice.
Category2 is a status of In Progress. I am trying to count how many rows are In Progress for Merchandising.
Any help would be greatly appreciated. Thank you!
