Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Counting unique text/number cells from a range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
complex fomula: counting cells that are blank | Excel Worksheet Functions | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions |