Counting number of X's in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=COUNTIF(A:A,"X")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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 said:
=COUNTIF(A:A,"X")

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Back
Top