| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compound condition with COUNTIF
I want to be able to count values between 2 dates in a table. The query will
look something like: =COUNTIF('Roll Out Schedule 23-Nov-05'!$H$3:$H$953,AND("27/11/05","<05/12/05")) Can anyone tell me where I'm going wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compound condition with COUNTIF
=COUNTIF('Roll Out Schedule 23-Nov-05'!$H$3:$H$953,"27/11/05-
COUNTIF('Roll Out Schedule 23-Nov-05'!$H$3:$H$953,"05/12/05") -- HTH RP (remove nothere from the email address if mailing direct) "Mike McLellan" wrote in message ... I want to be able to count values between 2 dates in a table. The query will look something like: =COUNTIF('Roll Out Schedule 23-Nov-05'!$H$3:$H$953,AND("27/11/05","<05/12/05")) Can anyone tell me where I'm going wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| countif condition problem | Excel Worksheet Functions | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF with compound comparison | Excel Worksheet Functions | |||
| Countif - Countif | Excel Worksheet Functions | |||
Linear Mode
