[help] sum cells with the same name

[theriddlept]

Hello

Sorry, I'm new here...

Every day I enter some numbers for (Part A, Part B, Part C) then I make the product of them for another cell.
Ex.: Part A 2 4 2 16

The problem is sometimes I repeat the (Part A, Part B, Part C) but with differents numbers.

So, now I need to calculate the sum of the multiplication of people for each Part.

Sorry if I didn't explain well, but this is really confuse to me.

Thank you

[Phuocam]

Try:

=SUMIF($A$2:$A$8,M2,$F$2:$F$8)

[JohnTopley]

Try

=SUMPRODUCT(($A$2:$A$8=$M2)*($B$2:$B$8)*($C$2:$C$8)*($D$2:$D$8))

in N2 and copy down

[theriddlept]

Thank you guys ! It works !