Try something like:

=COUNTIF(A:A,"Word1")



"Patrick" wrote in message
...
I have 5 choices that are words for each cell in a column. How do I sum
the
total number of each word or assign a hidden number to each word? I'm
trying
to avoid using numbers because it puts the respondent off? I'd like to
use
colors. Any chance?

Thanks Much,

P.