Using COUNTIF:
=COUNTIF(A1:A12,"30")-COUNTIF(A1:A12,"100")
With SUMPRODUCT
=SUMPRODUCT(--(A1:A1230),--(A1:A12<100))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Satyendra_Haldaur" wrote in
message ...
Dear all;
I am trying to use countif with and like this.
COUNTIF(A1:A12,and("30","<100"))
I did try it with diffrent condition and even replace and with or but it
just show me answer 0.
is there any other way to use countif with multiple conditions?