Counting issues between dates

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Try something like this:

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

HTH,
Elkar
 
Fantastic! Thank you!
--
Many Thanks,
Paula


Elkar said:
Try something like this:

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

HTH,
Elkar
Click to expand...
 
Back
Top