COUNTIF when < value in reference cell

[daknight]

I have a formula that works great for counting values that equal my reference cells (D9 or D11)
=COUNTIF(D13:D112,D9)+COUNTIF(D13:D112,D11)

What I need is to COUNTIF a value in my range (D13:D112) are less than the value in D9 or greater than the value in D11.

Can anyone help me please? I have tried modifying the formula like this but it does not work:
=COUNTIF(D13:D112,"<D9")+COUNTIF(D13:D112,">D11")
I am an Excel 101 - thanks for any help!

Darla

 

[ChrisM]

Which version of Excel? If 2007+, use the COUNTIFS function, it takes multiple criteria

 

[Marcelo Branco]

Maybe

=COUNTIF(D13:D112,"<"&D9)+COUNTIF(D13:D112,">"&D11)

HTH

M.

 

[Jonmo1]

Do you really mean OR ?

That would be

=COUNTIF(D13:D112,"<" & D9)+COUNTIF(D13:D112,">" & D11)


Or do you mean AND, as in BETWEEN D9 and D11?

If that's the case, use sumproduct

=SUMPRODUCT(--(D13:D112 < <?XML:NAMESPACE PREFIX = D9),--(D13 /><D9),--(D13:D112>D9),--(D13:D112 > D11))
</D9),--(D13:D112>

 

[daknight]

THANK YOU!!!

This works perfectly!!
=COUNTIF(D13:D112,"<"&D9)+COUNTIF(D13:D112,">"&D11)

(I did want OR - either below the minimum or over the maximum allowable)
Thank you very much!!
Darla

 

[Marcelo Branco]

You are welcome!!!

Glad to help

M.