=COUNTIF(A1:A100,"*A*")

"Christopher Naveen" wrote:

Hi,

I have a col and i need to check for a text in a cell and i required the
count.

EX :

ABC 115
DEF 245
ADD 515
FAC 576

So here i want to know how many cell contains "A".

I required the count. Answer is 3

same way in Nos. col i required how many cell contains "5". Answer is 4

Can any one help me to get it.

I can do it in filters == custom == contains == but i need it by formula.

-Christ.