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. |
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 |