You want to do this in a macro or using a worksheet function?

If you just want to do it in a worksheet function, then put your curso
where you want the result to be and click on "Insert Function".
Select the "Countif" function. The wizard will help you set up th
formula. You want something like this:

=COUNTIF(A1:A30,"X"

--
Message posted from http://www.ExcelForum.com