sum using three columns

[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

 

[Guest]

=SUMPRODUCT(--(CA1:CA100="Op 5"),--(CB1:CB100="Limit Fault"),CC1:CC100)

You could put the "Op 5" and "Limit Fault" value in cells and refrence the
cells in the formula:

=SUMPRODUCT(--(CA1:CA100=X1),--(CB1:CB100=Y1),CC1:CC100)

HTH

 

[Pete_UK]

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