Need to combine countIF with AND for selection criteria
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!
|