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

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?

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

You can count the number of times a "thing" occurs in a column with COUNTIF():


=COUNTIF(B2:B4,"X") in cell B5
--
Gary's Student


"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?

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

Try...

=COUNTIF(B2:B4,"X")

Hope this helps!

In article ,
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?

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?

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

I have a similar problem.

Trying to get a word(s) in a column on Sheet2 to total in a cell on
Sheet1. So down Column C, how many times the word "Off" or "On"
appears to total on Sheet1 under their perspective rows of "Off" and
"On".


--
respinosa
------------------------------------------------------------------------
respinosa's Profile: http://www.excelforum.com/member.php...o&userid=35231
View this thread: http://www.excelforum.com/showthread...hreadid=549633

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

=COUNTIF(Sheet2!C:C,"on")

=COUNTIF(Sheet2!C:C,"off")

="On = "&COUNTIF(Sheet2!C:C,"on")&CHAR(10)&"Off =
"&COUNTIF(Sheet2!C:C,"off") formatted for WrapText.


Vaya con Dios,
Chuck, CABGx3




"respinosa" wrote
in message ...

I have a similar problem.

Trying to get a word(s) in a column on Sheet2 to total in a cell on
Sheet1. So down Column C, how many times the word "Off" or "On"
appears to total on Sheet1 under their perspective rows of "Off" and
"On".


--
respinosa
------------------------------------------------------------------------
respinosa's Profile:
http://www.excelforum.com/member.php...o&userid=35231
View this thread: http://www.excelforum.com/showthread...hreadid=549633