View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default Assign Values to text cells

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