Cumulative sum using unique identifier

[Aureus3]

Hi all,

I'd like to create a running sum of total shipped (in column D using column C data) based on the unique identifier (in column A). This list can be added to and is unsorted so I need to include the entire range of the columns in use.
My current formula will work if the shipments do not exceed two instances but fails on anything greater. I need it to return the cumulative shipped (shipment 1, shipment 1 + 2, shipment 2 + 3, etc).

May you please see the attached and advise? I'm using Office 365.


Thanks in advance,

James

 

[Fluff]

How about

=sumifs(c$2:c2,a$2:a2,a2)

 

[Aureus3]

How about

=sumifs(c$2:c2,a$2:a2,a2)

Thanks a lot!

 

[Fluff]

You're welcome & thanks for the feedback.