How to count X's in a column

M

Marie1uk

Hi,

I need to count the number of X's that appear in column B. What would
the best function be to do this?

Many thanks,

Marie
 
B

Bob Phillips

=COUNTIF(B:B,"X")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top