dimanche 17 octobre 2021

Trying to count instances of a name while referencing a list of names. Sum() doesn't appear to be working

I am attempting to count instances of each name on a list that appear in a column.

Column: Joe Mary Joe Jason Derek Joe

List of names: Joe Mary Jason Derek

My current code looks like this: =SUM(IF(IFFERROR(SEARCH(A$1:A$6,B1),0)1,0))

The result inside the SUM() is {1;0;1;0;0;1}.

SUM() should add those 1's up and produce "3".... but, it doesn't.

Anyone know what I'm missing here?

Thank you in advance!

Aucun commentaire:

Enregistrer un commentaire