sum using three columns
Try this:
=SUMPRODUCT((CA1:CA4=CA10)*(CB1:CB4=CB10)*(CC1:CC4 ))
assuming your data occupies rows 1 to 4 (adjust to suit) and that your
summary table begins on row 10 in the same columns (adjust to suit).
Copy the formula down to row 12. Hope this helps.
Pete
On Apr 3, 7:55 pm, "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
|