| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
... Count Function ... with any character ...
I have a count function; ( =COUNT(C4:Z4) )
I have my cells formated to display an (" X ") for any number that is entered. The function works well. But, I'd like to know if there is a way I can type any character into the cells instead of just numbers? (I'd like to have the "any character" be displayed as (" X ")). Darrell |
|
#2
|
|||
|
|||
|
Dr. Darrell,
If you want to count the cells that contain any character (numbers as well as strings), use =COUNTA(C4:Z4) Regards, B.R.Ramachandran "Dr. Darrell" wrote: I have a count function; ( =COUNT(C4:Z4) ) I have my cells formated to display an (" X ") for any number that is entered. The function works well. But, I'd like to know if there is a way I can type any character into the cells instead of just numbers? (I'd like to have the "any character" be displayed as (" X ")). Darrell |
|
#3
|
|||
|
|||
|
Thank you, that works.
Now I need to format my cells to display " X " no mater what character is typed in. Darrell "B. R.Ramachandran" wrote: Dr. Darrell, If you want to count the cells that contain any character (numbers as well as strings), use =COUNTA(C4:Z4) Regards, B.R.Ramachandran "Dr. Darrell" wrote: I have a count function; ( =COUNT(C4:Z4) ) I have my cells formated to display an (" X ") for any number that is entered. The function works well. But, I'd like to know if there is a way I can type any character into the cells instead of just numbers? (I'd like to have the "any character" be displayed as (" X ")). Darrell |
|
#4
|
|||
|
|||
|
Give it a custom format of:
X;X;X;X Dr. Darrell wrote: Thank you, that works. Now I need to format my cells to display " X " no mater what character is typed in. Darrell "B. R.Ramachandran" wrote: Dr. Darrell, If you want to count the cells that contain any character (numbers as well as strings), use =COUNTA(C4:Z4) Regards, B.R.Ramachandran "Dr. Darrell" wrote: I have a count function; ( =COUNT(C4:Z4) ) I have my cells formated to display an (" X ") for any number that is entered. The function works well. But, I'd like to know if there is a way I can type any character into the cells instead of just numbers? (I'd like to have the "any character" be displayed as (" X ")). Darrell -- Dave Peterson |
|
#5
|
|||
|
|||
|
Thank you very much.
Darrell "Dave Peterson" wrote: Give it a custom format of: X;X;X;X Dr. Darrell wrote: Thank you, that works. Now I need to format my cells to display " X " no mater what character is typed in. Darrell "B. R.Ramachandran" wrote: Dr. Darrell, If you want to count the cells that contain any character (numbers as well as strings), use =COUNTA(C4:Z4) Regards, B.R.Ramachandran "Dr. Darrell" wrote: I have a count function; ( =COUNT(C4:Z4) ) I have my cells formated to display an (" X ") for any number that is entered. The function works well. But, I'd like to know if there is a way I can type any character into the cells instead of just numbers? (I'd like to have the "any character" be displayed as (" X ")). Darrell -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clock | Excel Worksheet Functions | |||
| Count If Function | Excel Worksheet Functions | |||
| count if function with if statements | Excel Worksheet Functions | |||
| HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL? | Excel Discussion (Misc queries) | |||
| COUNT function and errors within it - Need some expert knowledge | Excel Discussion (Misc queries) | |||
Linear Mode
