SUMPRODUCT to establish whether turnaround date was achieved

[Guest]

I need to be able to establish whether statuses were adhered to, e.g. if a
task was urgent, was it completed within 2 days; if a task was high, was it
completed within 5 days.

Date Submitted Status Date implemented
10/10/06 Urgent 14/10/06
11/10/06 High 18/10/06
15/10/06 Medium 19/10/06
16/10/06 Low 20/10/06

NB Each status has its own value, e.g. Urgent = 2 days, High = 5 days,
Medium = 10 days, Low = >10 days

Any help gratefully appreciated. Thanks in advance.

 

[Bob Phillips]

=IF(C2-A2>LOOKUP(B2,{"High","Low","Medium","Urgent"},{5,9999,10,2}),"Not
Met","Met")

and copy down


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)