=COUNTA(B2:B53)

Will count all cells that are not empty.

Biff

"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