Hi Stephen,

Thank u very much. I got it. Can u pls tell me how can we count the Nos. in
count if function.

Ex : 55666665
55002422

Ans : 5

Now i need to count how many 5's are ther in both the cells.

-Christ

"Stephen" wrote:

Assuming the data are in column A:
=COUNTIF(A:A,"<"&"")
will give the number of cells with something in them (in your example, 6).
=COUNTIF(A:A,"="&"CDE")
will give the number of cells containing "CDE" (e.g 1).
=COUNTIF(A:A,"="&"ABC")
will give the number of cells containing "ABC" (e.g. 3).
So to get the answer you require, use
=COUNTIF(A:A,"<"&"")-COUNTIF(A:A,"="&"CDE")-COUNTIF(A:A,"="&"ABC")

"Christopher Naveen" wrote in
message ...
David,

Pls help me in this..

Thanks in advance.

-Christ

"Christopher Naveen" wrote:

Hi David,

Pls refer the below example,

ABC
ABC
CDE
EFG
EFG
ABC

I have some data's in a col as mentioned above. Now i use countif to
count
the values. I want to count only "ABC" in that Col and subtract with the
total no. of Rows and reject some values in that col.

Refer the detail explaination below,

I have totally 6 rows.
"ABC" = 3,
"CDE" = 1,
"EFG"=2

I want to know the count of
= Total (6 rows) that does not includes "CDE" - "ABC"

Ans : (6 - 1) - 3 = 2

Pls help me how to calculate this............

Thanks in advance.

-Christ

"David Biddulph" wrote:

=LEN(A2)-LEN(SUBSTITUTE(A2,"A",""))
--
David Biddulph

"Christopher Naveen"
wrote in
message ...

... Also pls tell me how can we find that how
many A's i have in a cell,

Ex :

AAAABBN
AHHH
AQREE
AA
....