Counting issues between dates
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 |
Counting issues between dates
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 |
Counting issues between dates
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 |
All times are GMT +1. The time now is 04:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com