79681083

Date: 2025-06-26 19:57:53
Score: 0.5
Natty:
Report link

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)))))

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: rotabor