- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 June
- How do I get text to equal a number so I can sum a column?

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?

- Re: How do I get text to equal a number so I can sum a column? posted by Domenic on Wed, 07 Jun 2006
- RE: How do I get text to equal a number so I can sum a column? posted by Gary''s Student on Wed, 7 Jun 2006
- RE: How do I get text to equal a number so I can sum a column? posted by CLR on Wed, 7 Jun 2006