With your list in column A (from cell A1 to cell A85):
In cell B1:
=SUMPRODUCT(--($A1=$A$1:$A$85))
Copy down to cell A85.
Cells D1 to D10 contain the numbers 1 to 10.
In cell E1:
=SUMPRODUCT(--($B$1:$B$85=$D1))
Copy down to cell E10.

"Kelvin" wrote:

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