Countif formula with multiple criteria ie >30 and <60?

[Dali]

What is the syntax for writing a CountIf formula to find items that are >30
and <60 from a range of numbers?

I tried =COUNTIF(Days_to_Process_Query!$D$2:$D$20840,">60 and <=90") and it
doesn't work.

 

[Don Guillett]

You can use 2 countifs or
=sumproduct((rnga>60)*(rngA<=90))

 

[Dave R.]

The numbers in your sentence don't match those in the formula, but one way
is to count the number greater than 30 then subtract the number greater than
60.

=COUNTIF(A1:A100,">30")-COUNTIF(A1:A100,">60")