Order Database Calculations

[razzandy]

I have a list of order numbers in column A which can get duplicated if there is more than one item per order. What I want to do is have a formula result in column C which would calculate weights entered in Column B. So if a particular order had only one line item there would be only one weight and it would give a Total weight in Column C. If there were duplicate order numbers due to multiple line items in one order I would like a Total weight for all the line items relating to that order. So an example would look like below.

A ¦ B ¦ C
Order# ¦ Weight Kg ¦ Total Weight kg
123 ¦ 100 ¦ 100
124 ¦ 80 ¦ 125
124 ¦ 45 ¦ 125
125 ¦ 130 ¦ 130

Thanks in advance

 

[tweedle]

To get your requested response:
C2:: =SUMIF(A:A,A2,B:B)
copy down

To get a single value per order
C2:: =IF(A2=A3,"",SUMIF(A:A,A2,B:B))
copy down

 

[razzandy]

Thanks tweedle

I’ve become out of practice with Excel over the years but I did manage to find the sumif formula in my past posts after I posted this thread.

But the addition to get a single value is great and will be really useful for me

So thanks all round

Cheers