View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kierano Kierano is offline
external usenet poster
 
Posts: 29
Default SUMPRODUCT to establish whether turnaround date was achieved

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.