count cells in a coloumn with letter x in it

sarg · Sep 24, 2005

excel2003
i wanna count cells in a coloumn that contain a specific letter like "X" or
whatever

Alan · Sep 24, 2005

=COUNTIF(A1:A100,"*X*")
Regards,
Alan.

Bob Phillips · Sep 24, 2005

=COUNTIF(A:A,"X")