| 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 | |||
Hybrid Mode
