View Single Post
  #1   Report Post  
Dali
 
Posts: n/a
Default Countif formula with multiple criteria ie >30 and <60?

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.