checking for a string & No.
=countif(A:A,"*A*")
--
Regards,
Fred
"Christopher Naveen" wrote in
message ...
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.
|