View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeB MikeB is offline
external usenet poster
 
Posts: 9
Default 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!