Sum Based On condition!

[r_know]

Dear All,

I have following column,

D E L O
00:15 4 1 Result
00:30 1 2
1:15 1 3
2:00 2 4
9:50 1 5

I want a formula in O column, if first criteria in L column 1, so find the L1=1 in the E column and do summation respective figures for time in D column.
Like for 1, 00:30+1:15+9:50= 11:35

Please can any one suggest formula?

Regards, RL>

[mrojas]

Could you post Excel file?

[mancubus]

the criteria for column E come from column L i think... if so, SUMIF will suffice... paste below formula in O1 and copy down... change my bottom row 500 to your actual row number or use a dynamic range.
=SUMIF($E$1:$E$500,$L1,$D$1:$D$500) ps: dont forget formatting the sum cells as [h]:mm

[r_know]

Yes Done
Also there is any possibility of use SUMPRODUCT formula.

[mancubus]

sure. and why?
=SUMPRODUCT(($E$1:$E$500=$L1)*($D$1:$D$500))

[r_know]

Perfect
Many Thanks mancubus~

[mancubus]

you are welcome r_know.