Counting "X"s in a column

[YBeaupre]

Hi,

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

Thanks

 

[Elkar]

Try this:

=COUNTIF(A1:A100,"X")

HTH,
Elkar

 

[YBeaupre]

Hi Elkar,

Many thanks. It does exactly what I wish.