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?