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

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

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

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

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