Excel 2003
I have a row of data in Excel that is in Row 4 from Column B to Column AF.

In this row, some cells contain the value "X", some contain the value "O",
and yet other cells in this row will contain other text data.

I tried the COUNTA function but that counts every cell that has a non-null
value. I need more spoecific information than that. I also tried it with an
immediate if, but somehow got the syntax incorrect.

Per my example above, is there a way in VBA to count across row 4 (from cell
B4 to cell AF4 how many cells contain the value of "X" and place that in cell
A5 and count how many cells contain the value of "O" and place that value in
cell A6?


Thanks.