Using COUNTIFS with CONTAINS

Using COUNTIFS with CONTAINS

Hello,

I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this:


=COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True")


The return value that I get is "0," which is not correct.

Is there another formula that I can try?

Best Answer

Answers

Sign In or Register to comment.