Countifs + find formula
I have a formula I'm having an issue with. I'm trying to count how many projects are assigned to a individual in the "Assigned To" column that contains a partial description "green Ties" in the "task Name" column.
here's my formula I came up with and need help to get it right.
=COUNTIFS([Assigned To]1:[Assigned To]160, =Dan R,[Task Name]1:[Task Name]160, FIND("green Ties" @cell) > 1)
Help Article Resources
Check out the Formula Handbook template!