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

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

Assign Values to text cells
 

=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

Assign Values to text cells
 

The COUNTA worksheet function will count non blank cells, so if you put a
formula into a cell such as =COUNTA(B2:B53) you should get a total for the
number of signatures entered.

"Josh" wrote:

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

Assign Values to text cells
 

Thank you all for your responses it worked perfect.

"bigwheel" wrote:

The COUNTA worksheet function will count non blank cells, so if you put a
formula into a cell such as =COUNTA(B2:B53) you should get a total for the
number of signatures entered.

"Josh" wrote:

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