Formula needed please :-)

[Kelly Johns]

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 are:

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/tutorial...c0-f6d27700d926/ado-to-adonet-syntax-tra.aspx

 

[Luke M]

All arrays within SUMPRODUCT must be of equal size.

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

Review Case Conferneces Not on time:
=SUMPRODUCT(--(P210="Review"),--(AD2:AD10>80))

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

Initial Case Conference Overdue by more than a week:
=SUMPRODUCT(--(P210="Initial"),--(AD2:AD10>87))

Initial case Conferences Overdue by less than a week:
=SUMPRODUCT(--(P210="Initial"),--(AD2:AD10>80),--(AD2:AD10<=87))