Hi,
Can anyone pls tell me how do i count the total number of cells that has
a certain word appear twice or nth times in a column?

The below-mentioned will be the end result. The frequency will be specified
by the user and excel will count the number of cells that has a certain word
appearing twice in a column. Likewise, for Freqeuncy 3, sums the number of
cells with that has a certain word in a string that appears thrice in the
column.

Frequency(input) Number of occurences(output)
2 10
3 \30