count with and formula

[Satyendra_Haldaur]

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?

 

[Bernard Liengme]

Using COUNTIF:
=COUNTIF(A1:A12,">30")-COUNTIF(A1:A12,">100")
With SUMPRODUCT
=SUMPRODUCT(--(A1:A12>30),--(A1:A12<100))
best wishes

 

[Shane Devenshire]

Hi,

If you are using 2007 then

=COUNTIFS(A1:A12,">30",A1:A12,"<100")

Its more flexible to use cell references:

=COUNTIFS(A1:A12,">"&C1,A1:A12,"<"&C2)

Where C1 contains 30 and C2 100.