Assign Values to text cells
I have a form i use where different People sign off with there initials
such as I would sign off with "JE" i need a total of the signitures. How can
have the total number of cells that contain a signiture be recognized as "1"?
If the form were to fill I would have cells B2-B53 taken up. Is there a way
to make a cell with text in it equal 1 and a blank cell equal 0?
Please help. Thanks
|