... Count Function ... with any character ...

D

Dr. Darrell

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
 
B

B. R.Ramachandran

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
 
D

Dr. Darrell

Thank you, that works.

Now I need to format my cells to display " X " no mater what character is
typed in.

Darrell
 
D

Dave Peterson

Give it a custom format of:

X;X;X;X

Dr. Darrell said:
Thank you, that works.

Now I need to format my cells to display " X " no mater what character is
typed in.

Darrell
Click to expand...
 
Top