G
Guest
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.
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.