Thread: 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((rnga>60)*(rngA<=90))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Dali" <Dali@discussions.microsoft.com> wrote in message
news:5B22E5DF-E9EF-4E81-AC3B-5A86FBBF9451@microsoft.com...
> 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" <Dali@discussions.microsoft.com> wrote in message
news:5B22E5DF-E9EF-4E81-AC3B-5A86FBBF9451@microsoft.com...
> 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.