View Single Post
  #3   Report Post  
Dave R.
 
Posts: n/a
Default

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


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