Summing words

P

Patrick

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

asyado

Hi Patrick,

Do you mean you want to count the number of times say "RED" is returned by
the user?
if so then you still don't need to assign a number.
Use =COUNTIF(range,"RED")
where range is the range of cells that you want to examine.
 
Top