View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

You can use 2 countifs or
=sumproduct((rnga60)*(rngA<=90))

--
Don Guillett
SalesAid Software

"Dali" wrote in message
...
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.