SUM Product

S

storm warden

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.
 
B

Barb Reinhardt

Several questions:

Is the STK ID in column A, state in column F, etc?

When does your work week start and end? Friday, Saturday, something else?
 
S

storm warden

Sorry, Yes

I have tried sum product or sumif and i cannot seem to get them to work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top