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