Consolidate the Sum of numbers in multiple rows when they have a unique reference

[Age808]

Hi Everyone, I've spent a little bit of time playing around with this and haven't manged to find a solution yet so I'm grateful for any assistance.

I have some order data that I need to consolidate to calculate some shipping charges. I've attached a sample data set which has 2 tabs. The 'data' tab is a snippet of the master data whilst the 'outcome' tab is the desired outcome of the consolidated rows.

Where the rows have the same sales order number (Column A), I need to consolidate the sum of column R (Dead Weight) and S (Cubic Volume) so that the consolidated data appear in 1 row as illustrated in the 'outcome' tab.

Any ideas?

[protonLeah]

=SUMIF(Data!$A$2:$A$19,Outcome!$A2,Data!R2:R19)

[Age808]

Thanks a lot!