Count-formula used for words
 

Is it possible to count different words?
If yes how is the formula?

Thanks!


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=507211

Count-formula used for words
 

It is possible, but the solution depends on one or two things. Suppose
you're looking for the word "blue": will the cells in question contain
*just* the word blue, or might it be contained in a text string such as
"the sky is blue"? Do you want to count a handful of words, and if
yes, do you mind counting one at a time or do you need to count them
all at once (for instance, count red, white, and blue in separate
formulas, or all in one formula)?

Count-formula used for words
 

You can use the COUNTIF function to count specific words
You can use SUMPPRODUCT to count unique words

Example:
A1 the
A2 boy
A3 ran
A4 fast
A5 boy
A6 =COUNTIF(A1:A5,A1) returns 1
A7 =COUNTIF(A1:A5,"boy") returns 2
A8 =SUMPRODUCT(--(COUNTIF(D3:D8,D3:D8)=1)) returns 3

If you need something more specific, then be more specific with your question.

"Vic1978" wrote:


Is it possible to count different words?
If yes how is the formula?

Thanks!


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=507211