sum using three columns
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
|