=SUMPRODUCT(--(CA1:CA100="Op 5"),--(CB1:CB100="Limit Fault"),CC1:CC100)

You could put the "Op 5" and "Limit Fault" value in cells and refrence the
cells in the formula:

=SUMPRODUCT(--(CA1:CA100=X1),--(CB1:CB100=Y1),CC1:CC100)

HTH



"kevcar40" wrote:

Hi
i am trying to sum the time values of a fault against an operation
column CA hold the operation identification
column CB holds the fault
column CC holds the time values

eg
CA CB CC
op 5 limit fault 15
op 5 clamp 20
op 10 limit fault 10
op 5 limit fault 10


this should return
op 5 limit fault 25
op 5 clamp 20
op 10 limit fault 10
can anyone help with a formula


thanks


kevin