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!

Need to combine countIF with AND for selection criteria
 

Have you tried using SUMPRODUCT? I would normally give a link to Bob
Phillips' site:

http://www.xldynamic.com

which has a very good explanation of this function, but the site
seemed to be down when I just tried it.

Hope this helps.

Pete

On Jun 17, 11:45*pm, MikeB wrote:
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!