View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default 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