Contains Function cannot find value for contact list data type

Anthony893

Hello,

I'm trying to use the COUNTIF and CONTAINS functions to count the values in the percent column based off the values in the Names column with the contact list column type.

Here is the formula I have so far:

=SUMIF(Names1:Names3, CONTAINS("Anthony", @cell), Percent1:Percent3)

And here is the data:

When I change the data type to text, it works. But when I have the Names column set to the contact list data type, it returns 0 (I'm assuming that means the CONTAINS function found no matches).

Is there a different function I should be using other than CONTAINS that will work with contact lists?

Thanks!

Anthony

=Chris Palmer

Hello @Anthony893

In my experience using formulas on Contacts List columns can be problematic.

You may want to explore using a helper column next to "Names" that is text with ="[Names]@row"

Then use your formula against the helper column to achieve your desired result.

Anthony893

Hey @Mr. Chris,

Thanks for the quick reply, I think that's going to be my best solution.