Dashboard formulas - Need to count if a person is included in Owner Column and the task is not close

JFrye

Trying to calculate the number of tasks by person that are not closed. I currently have:

=COUNTIFS({Tracker Range 6}, ="Andy", {Tracker Range 2}, <>"CLOSED")

Where the Range 6 is the Owner column and Range 2 is the Status Column (Open, Closed, Hold). 

I am getting responses, but I think it is only counting where the owner is the only entry in the cell...many have shared ownership. How do I indicate where the name is included and not the only entry?

Nic Larsen

Try something like this: 

=COUNTIFS({Tracker Range 6}, FIND("Andy", @cell) > 0, {Tracker Range 2}, OR(@cell = "Open", @cell = "Hold"))

JFrye

Thank, Nic! Worked like a charm! Appreciate it!

 

Nic Larsen

Perfect, glad to help.