Formula needed please :-)
 

P V AE AD
Initial/Review Initial on time Review ontime Days Betwe

Initial Yes n/a 63
Review n/a Yes 71
Review n/a Yes 85
Initial Yes n/a 163
Initial Yes n/a 81
Review n/a Yes 115
Initial No n/a 60



The questions I need answered a

Review Case Conferences on time:

Review Case Conferneces Not on time:

Initial Case Conference on time

Initial Case Conference Overdue by more than a week:

Initial case Conferences Overdue by less than a week:

Please note that to be ontime it has to be 80 days or less. Overdue is 81 days or more.

Thank-you very much.


EggHeadCafe - Software Developer Portal of Choice
ADO To ADO.NET Syntax Translation/Comparison
http://www.eggheadcafe.com/tutorials...yntax-tra.aspx

Formula needed please :-)
 

All arrays within SUMPRODUCT must be of equal size.

Review Case Conferences on time:
=SUMPRODUCT(--(P2:P10="Review"),--(AD2:AD10<=80))

Review Case Conferneces Not on time:
=SUMPRODUCT(--(P2:P10="Review"),--(AD2:AD1080))

Initial Case Conference on time
=SUMPRODUCT(--(P2:P10="Initial"),--(AD2:AD10<=80))

Initial Case Conference Overdue by more than a week:
=SUMPRODUCT(--(P2:P10="Initial"),--(AD2:AD1087))

Initial case Conferences Overdue by less than a week:
=SUMPRODUCT(--(P2:P10="Initial"),--(AD2:AD1080),--(AD2:AD10<=87))

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kelly Johns" wrote:



P V AE AD
Initial/Review Initial on time Review ontime Days Betwe

Initial Yes n/a 63
Review n/a Yes 71
Review n/a Yes 85
Initial Yes n/a 163
Initial Yes n/a 81
Review n/a Yes 115
Initial No n/a 60



The questions I need answered a

Review Case Conferences on time:

Review Case Conferneces Not on time:

Initial Case Conference on time

Initial Case Conference Overdue by more than a week:

Initial case Conferences Overdue by less than a week:

Please note that to be ontime it has to be 80 days or less. Overdue is 81 days or more.

Thank-you very much.


EggHeadCafe - Software Developer Portal of Choice
ADO To ADO.NET Syntax Translation/Comparison
http://www.eggheadcafe.com/tutorials...yntax-tra.aspx
.