I am struggling to find the sum of the count of appearance of substring in a string array. have attached the image with the problem statement and expected output. Tried using the length and substitute function to solve - did not help with sum but.

Screenshot (117).png

(LEN(C2)-LEN(SUBSTITUTE(C2, C4, "")))/LEN(C4)

Any help is appreciated.