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

sum using three columns
 

=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



"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

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