Josh,
This is a worksheet form? If the signatures are all in the same column, and
the other cells in the column are blank, count them with
=COUNTA(A2:A100).
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Josh" wrote in message
...
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