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

J

jimi

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

Gary''s Student

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


=COUNTIF(B2:B4,"X") in cell B5
 
R

respinosa

I have a similar problem.

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

CLR

=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
 
Top