Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing words
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing words
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing words
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. -- John "Patrick" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel underline misspelled words like Word? | Excel Discussion (Misc queries) | |||
cannot get color in cells and words | Setting up and Configuration of Excel | |||
Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
triadic combinations of words | Excel Worksheet Functions | |||
Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) |