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