Counting words from a lookup text

Hi everyone !

I have been looking for a solution to count specific words from a text extract with the lookup tool in vain.

In this example I would to count the number of car in a special state of development of each brand, does a solution exist ?

I would also be interested to know if is possible to convert the technology column into a “multi-select” column, to know all the technologies used by each brand without repetition.

Thank you !