count with and formula

  • Thread starter Thread starter Satyendra_Haldaur
  • Start date Start date
S

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?
 
Using COUNTIF:
=COUNTIF(A1:A12,">30")-COUNTIF(A1:A12,">100")
With SUMPRODUCT
=SUMPRODUCT(--(A1:A12>30),--(A1:A12<100))
best wishes
 
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.
 
Back
Top