View Single Post
  #1   Report Post  
Kelvin
 
Posts: n/a
Default Counting cells with a specified frequency(how many times it appear

Hi,
I want to sum up cells thats has any word appearing 10 times in the
column. In the other words, the specified word can be anything. The end
result is to the sum up cells that has any word appear 10 times in the column.

eg.
column 1
row 1 a two the
row 2 two 924 the
row 3 the desk to
row 4 let's can to two

if i want to sum up the cells that has any word appearing twice, the result
will be 1
word frequency of 3, the answer will be 2 (row 1 - the & two, row 2, row 3
- the, row 4 two)

Thanks