How to find the count of occurance

[Priyap2023]

I want to find the count of occurance of list of words in a column.  Example I have list of words as below,

1.Violation 

2.Vulnerability 

I want to count the occurance of these words in summary column of the excel file

Summary column values

1. Violation identified in abc

2. Vulnerability are identified in xyz

3. Violation identified in ccccc

Expected output:

Violation 2

Vulnerability 1

[binuacs]

@Priyap2023 One way of doing this