Thread: How do I get text to equal a number so I can sum a column?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default How do I get text to equal a number so I can sum a column?
=COUNTA(B2:B4)

Vaya con Dios,
Chuck, CABGx3



"jimi" wrote:

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?
Reply With QuoteReply With Quote