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

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

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

[Domenic]

Try...

=COUNTIF(B2:B4,"X")

Hope this helps!

In article <[email protected]>,
jimi <[email protected]> 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?

[CLR]

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

[respinosa]

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

[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




"respinosa" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>