K
kevcar40
Hi
I have to two formulas below
the first returns the time values of a column (works no problem)
SUMIF(AI:AI,AJ2,CC:CC)
what i am trying to do with the second column is sum the time value of
the fault only if the fault occurrs against an operation
how can i merge the two fomulas
so when a fault is found the operation checked and the time value is
calculated only where the fault and operation are the same
SUMPRODUCT((CA2:$CA$12000=$AC$6)*(CB2:$CB$12000=AI2)*(CC2:$CC$12000))
thanks
kevin
I have to two formulas below
the first returns the time values of a column (works no problem)
SUMIF(AI:AI,AJ2,CC:CC)
what i am trying to do with the second column is sum the time value of
the fault only if the fault occurrs against an operation
how can i merge the two fomulas
so when a fault is found the operation checked and the time value is
calculated only where the fault and operation are the same
SUMPRODUCT((CA2:$CA$12000=$AC$6)*(CB2:$CB$12000=AI2)*(CC2:$CC$12000))
thanks
kevin