Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |