[MikeB]

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!

[Pete_UK]

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!