Calculate total wait based on other duplicate cells.

[JumpInTheFire83]

Hi,

I've hit a wall!

I am looking a solution to the below image. As you can see, Coloumn A has Order Number, B has weight and C has total weight.

In C, is it possible to have a formula that will calculate the total weight of rows 5 & 6 as this is the same order.

 

[123rickfear]

do you want rows 5 and 6 to both show 74? if so:

=SUMIF(A:A,A2,B:B) and drag down

if you only want the first entry (row 5) to show the total then use =IF(COUNTIF($A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"") and drag down.