sum using three columns

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
 
T

Toppers

=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
 
P

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
 
Top