Counting number of X's in a column

[Susie Harris]

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.

 

[Bob Phillips]

=COUNTIF(A:A,"X")

--

HTH

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

 

[Susie Harris]

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

=COUNTIF(A:A,"X")

--

HTH

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