Thread
:
Countif formula with multiple criteria ie >30 and <60?
View Single Post
#
2
Don Guillett
Posts: n/a
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.
Reply With Quote