countif times by amount in 2nd cell

[matkalg1]

Hi All
I would like to countif from a range of cells from (T5:T187) but i want it to multiply it by the amount in its corresponding cells from (L5:T187), so example is that i want the unique part codes in 'T' column and the total amounts of each part code from column 'L'. Can anyone help please

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUMPRODUCT(--($T$5:$T$187=P191),$L$5:$L$187)

 

[matkalg1]

Hi & welcome to MrExcel.
How about

=SUMPRODUCT(--($T$5:$T$187=P191),$L$5:$L$187)

Hi Fluff

Thanks for that, works a treat

 

[Fluff]

You're welcome & thanks for the feedback.