Count-formula used for words

[Vic1978]

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

Thanks!

[Dave O]

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)?

[Sloth]

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
>
>