The solution for you is:
[C1]=REDUCE(0,A1:A4, LAMBDA(a,x,IF(ISNUMBER(x),a+(x=B1),a+SUM(N(VALUE(TEXTSPLIT(x,";"))=B1)))))