Counting number of X's in a column
 

I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get one
to work. We are using Excel 2003.

Thank you.
--
Susie Harris
Operations Manager
Environmental Education Association of Washington

Counting number of X's in a column
 

=COUNTIF(A:A,"X")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Susie Harris" wrote in message
...
I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get
one
to work. We are using Excel 2003.

Thank you.
--
Susie Harris
Operations Manager
Environmental Education Association of Washington

Counting number of X's in a column
 

Bob,
Ohmigosh!!!! That is just too simple. Thank you so much. I was waaayyy too
stuck on an if statement.
--
Susie Harris
Operations Manager
Environmental Education Association of Washington


"Bob Phillips" wrote:

=COUNTIF(A:A,"X")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Susie Harris" wrote in message
...
I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get
one
to work. We are using Excel 2003.

Thank you.
--
Susie Harris
Operations Manager
Environmental Education Association of Washington