| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple criteria date range
I'm trying to countif in 2 columns 1has "O" or "MV". The other column has
date ranges. So if dates 1/1/1985 -12/31/1985 "O" count how many. And do the same for "MV" within the same date range. Here is the formula im using. Not sure if I'm on the right track. It 's not working.... =COUNT(IF((G2:G1238="O")*(H2:H1238<12/31/1985)*(H2:H12381/1/1985),H2:H1238)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif with multiple criteria and date range | Excel Worksheet Functions | |||
| Sum multiple criteria with a range than and < than | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| look up with multiple criteria and within a range | Excel Worksheet Functions | |||
| Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
