Can anyone assist??
1/21/2006 ie
1/30/2006 ie
2/10/2006 mq
1/1/2006 mq

I have the following formula to count the number of dates that are listed
between 1/1/06 and 1/31/06.

=SUMPRODUCT(--(((A4:A8<=E12)*A4:A8)=E11))

I also have a formula that counts the number of issue types that appear in
column b(it references a list on another worksheet)

=COUNTIF(B5:B8,'ISSUE TYPES'!A5)


I want to combine the two formulas to give me the number of issues between
1/1/06 and 1/31/06 that contains the issue type that referenced.







--
Many Thanks,
Paula

Try something like this:

=SUMPRODUCT(--(A4:A8<=E12),--(A4:A8=E11),--(B4:B8='ISSUE TYPES'!A5))

HTH,
Elkar


"Billing Goddess" wrote:

Can anyone assist??
1/21/2006 ie
1/30/2006 ie
2/10/2006 mq
1/1/2006 mq

I have the following formula to count the number of dates that are listed
between 1/1/06 and 1/31/06.

=SUMPRODUCT(--(((A4:A8<=E12)*A4:A8)=E11))

I also have a formula that counts the number of issue types that appear in
column b(it references a list on another worksheet)

=COUNTIF(B5:B8,'ISSUE TYPES'!A5)


I want to combine the two formulas to give me the number of issues between
1/1/06 and 1/31/06 that contains the issue type that referenced.







--
Many Thanks,
Paula

Fantastic! Thank you!
--
Many Thanks,
Paula


"Elkar" wrote:

Try something like this:

=SUMPRODUCT(--(A4:A8<=E12),--(A4:A8=E11),--(B4:B8='ISSUE TYPES'!A5))

HTH,
Elkar


"Billing Goddess" wrote:

Can anyone assist??
1/21/2006 ie
1/30/2006 ie
2/10/2006 mq
1/1/2006 mq

I have the following formula to count the number of dates that are listed
between 1/1/06 and 1/31/06.

=SUMPRODUCT(--(((A4:A8<=E12)*A4:A8)=E11))

I also have a formula that counts the number of issue types that appear in
column b(it references a list on another worksheet)

=COUNTIF(B5:B8,'ISSUE TYPES'!A5)


I want to combine the two formulas to give me the number of issues between
1/1/06 and 1/31/06 that contains the issue type that referenced.







--
Many Thanks,
Paula