Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Product
Hi there,
I am experiencing a real issue with working out a formula to do the following I have a list of data from our trouble ticket system A:A STK ID 0000001 F:F STATE closed G:G Fault Start 17/05/04 12:30:00 H:H Fault Resolved 26/05/04 16:30:00 I:I SLA Target (days) 1 J:J Faut Duration (days) 9 K:K Performance (+ or - days) 8 L:L Breached or within SLA Breacked What i would like to do is to work out the number of tickets that were open and had breached SLA on during a particular working week. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Sum Up sales data by a product category from anther sheet | Excel Worksheet Functions | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Percentages | Charts and Charting in Excel | |||
How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions |