| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
... If I have text in a cell, can I use "COUNT"...
I am creating an audit sheet. I have 5 columns labled 0, 1, 2, 3-4, 5+. In
the cells below these labels I want to place "X"'s to indicate the number of incedences corisponding to the number in the labels. Can I use the COUNT function to record the number of "X"'s in the range of cells? (The COUNT Function works is I place numbers in the cells but doesn't seem to work if I have text in the cells.) Tnak you, Darrell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
... If I have text in a cell, can I use "COUNT"...
Darrell
COUNTA() totals text in cells Dan "Dr. Darrell" wrote: I am creating an audit sheet. I have 5 columns labled 0, 1, 2, 3-4, 5+. In the cells below these labels I want to place "X"'s to indicate the number of incedences corisponding to the number in the labels. Can I use the COUNT function to record the number of "X"'s in the range of cells? (The COUNT Function works is I place numbers in the cells but doesn't seem to work if I have text in the cells.) Tnak you, Darrell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
... If I have text in a cell, can I use "COUNT"...
Thank you.
"Michell Major" wrote: Darrell COUNTA() totals text in cells Dan "Dr. Darrell" wrote: I am creating an audit sheet. I have 5 columns labled 0, 1, 2, 3-4, 5+. In the cells below these labels I want to place "X"'s to indicate the number of incedences corisponding to the number in the labels. Can I use the COUNT function to record the number of "X"'s in the range of cells? (The COUNT Function works is I place numbers in the cells but doesn't seem to work if I have text in the cells.) Tnak you, Darrell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Count the number of Lines in a "wrap text"-cell | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
