sum a range

K

kevcar40

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
 
B

Barb Reinhardt

=Sumproduct(--(CA1:CA100="op 5"),--(CB1:CB100 = "limit fault"),(CC1:CC100)

You can replace the values in "" with something like = C10 where C10 = "op
5" if you want it to be more generic. Just ensure that the ranges in each
group of () are the same length.
 
Top