Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am first selecting to count valuses that fall between specific dates in a
column and have certain values in another colu,n. For the date selection I am using: =COUNTIF('Closed EDI Data SINCE 123107'!AZ2:AZ9999,"02/15/2008")- COUNTIF('Closed EDI Data SINCE 123107'!AZ2:AZ9999,"=02/22/2008") But I need to further define the count by a value stored in another Column: =+COUNTIF('Closed EDI Data SINCE 123107'!$AK$2:$AK$9999,'CLOSURE RATES _SEV'!$A4) I need to combine these so that only values that meet both the date and fileld value are counted. Appreciate any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I combine CountIf with IF or AND? | Excel Discussion (Misc queries) | |||
combine countif and sumproduct? | Excel Worksheet Functions | |||
How to combine SUMPRODUCT with COUNTIF? | Excel Worksheet Functions | |||
Combine COUNTIF & EXACT | Excel Discussion (Misc queries) | |||
How do I combine 2 COUNTIF formulas?? | Excel Worksheet Functions |