I am currently trying to use this function =SUMIF(A2:C5001, "*"&K2&"*",E2:E5001)...I am trying to take column A which has multiple numbers in each of the single cells, then I want to uniquely identify a number within that cell and I need it to count a number is a different cell.
EX:
A2: 1,3,6,10,12,13 E2: 1421 K2: 1

I want it to uniquely count just the number 1 but give me the number in E2 if 1 is there, but when I put 1 in my K2, it is also counting 10, 12, and 13 as well because there is a 1 in those number. How do I correct this?