Need a formula that will calculate a cell of text.

[Dixie]

I am creating a tracking worksheet of employees. I want to have a cell next
to their name(s) that automatically enters a value of 1. Then I can have a
sum at the end of the list that tells me how many individuals I have in a
particular category. Regardless of what text is in the cell I want the
result to calculate 1. I found a formula that counts words in a cell, but I
always want it to be 1. Is this possible?

 

[Ray A]

an option
=count(A1:A10)
Range is equal to category
HTH

 

[Dixie]

Ray,
I entered the formula and the result was zero. Any other options?

 

[Ray A]

Sorry Dixie
The count function is for numeric numbers
Use =counta(a1:a100)

 

[Dixie]

Thank you!!!!!!!!! It worked beautifully, just what I need!!!!!!