COUNTIF statement

[mdorman]

Is there any way to do a COUNTIF statement with two criteria?

For example:

COUNTIF(AND(X>5,X<10))

I tried using the above COUNTIF(AND statement, but it didn't work.

Any ideas would be greatly appreciated.

 

[just_jon]

Is there any way to do a COUNTIF statement with two criteria?

For example:

COUNTIF(AND(X>5,X<10))

I tried using the above COUNTIF(AND statement, but it didn't work.

Any ideas would be greatly appreciated.

COUNTIF(Range,">5")-countif(Range,">10")

 

[IML]

You could use
=COUNTIF(A1:A10,">5")-COUNTIF(A1:A10,">=10")
or
=SUMPRODUCT(COUNTIF(A1:A10,{">5",">=10"}),{1,-1})
with an array constant

 

[mdorman]

I knew there was a solution.

Thanks a bunch

 

[IML]

Please if you want to include numbers in between 5 and 10 (but excluding them) to use one of the formulations I suggested. Due to a subtle difference Just jon's will include 10s