How do I get text to equal a number so I can sum a column?

Giganews Newsgroups
Subject: How do I get text to equal a number so I can sum a column?
Posted by:  JimI
Date: Wed, 7 Jun 2006

I am creating an Excel document where I place the letter X in a column and
want those X's to be added up and totaled at the bottom row.  For example:
B2 - X
B3 - X
B4 - X
B5 - 3

As you can see, B5 has the result of 3 X's being input on B2:B4.  So, how do
I get the letter X to be recognized as a numerical 1 to be added?

Replies