Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT to establish whether turnaround date was achieved
=IF(C2-A2LOOKUP(B2,{"High","Low","Medium","Urgent"},{5,9 999,10,2}),"Not
Met","Met") and copy down -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kierano" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct with more than one date | Excel Discussion (Misc queries) | |||
count between start date and end date | Excel Discussion (Misc queries) | |||
sumproduct by date | Excel Worksheet Functions | |||
Sumproduct with Date column | Excel Worksheet Functions | |||
Using sumproduct to count number by date | Excel Worksheet Functions |