I am trying to build an active personnel spreadsheet. With the individuals
names listed in column "A", I need to give "X" a numerical value so that when
I add the X to account for this individual it will give the total active at
the bottom. I know the formula for the simple addition and understand how to
do that, however I can not figure out how to give a text a numerical value.