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

D

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.
 
D

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")
 
Top