Multiple Contact Cell in a COUNTIFS statement to only extract one name

Adrià Termes

Hi all.

I have been browsing the community for some time, but have been unable to find a solution to this issue. I have been trying to count a specific name from a multiple contact column, but calculations are not capturing the right number. I have tried two different approaches:

1. {E2E Framework Solutions Funnel Range 21}, FIND($[Metric NAme]@row, @cell) > 0) In this formula, I try to use the written name in Metric NAme in each row to see in the Range 21 (the multiple contact column) if we have it in there (with FIND, if superior to 0, it should mean we can capture it).
2. Same as above, but creating a helper column with a string (by adding + "") so that we can easily find if such name appears. It doesn't work either,

Does anybody have a quick tip on solving such issue? Do you think I need to create a helper column to check by person if it appears in the contact cell with a CONTAIN? Would really appreciate your help!

Eric Law

@Adrià Termes I would use either a helper sheet or the summary tab

=COUNTIF({E2E Framework Solutions Funnel Range 21}, CONTAINS(*use the name in quotes for summary tab or reference a name in a row if using summary sheet*,@cell))

Eric Law

@Adrià Termes I would use either a helper sheet or the summary tab

=COUNTIF({E2E Framework Solutions Funnel Range 21}, CONTAINS(*use the name in quotes for summary tab or reference a name in a row if using summary sheet*,@cell))

Adrià Termes

Yes, it works Eric!

Very probably I had issues with monstruous formulas. Separating into chunks can usually help.

Thank you very much!