Ok here is my senario:

I have a student roster with NAMES, NUMBERS, CODES, ETC. I would like to
assign the number 1 to each cell in the NAME column that has any type of text
in the cell. If there is no text then I would like to assign the number 0.

Exmpl:

Column A Column B

Joe Schmo 1
Tina Turner 1
George W. 1
"No Text" 0
Shizam 1
"No Text" 0
Balthazar 1

Total = SUM(B1:B7)