Hi Elkar,

Many thanks. It does exactly what I wish.

"Elkar" wrote:

Try this:

=COUNTIF(A1:A100,"X")

HTH,
Elkar


"YBeaupre" wrote:

Hi,

Can anyone tell me how to count the numbers of "X" in a column.

Thanks