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.

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.

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.