Sum of Order Total Based on Unique Order ID

Hello,

I'm trying to get the sum of a Column B based on the unique values in Column A. For example, column B has order totals and column A has the order IDs. Below is example of data from my spreadsheet. A couple things to note: 1) there's not always a pre-defined number of rows. 2) Order IDs are not always known so the function cannot specify the unique order IDs.

I'm sure there's a way to do this, but cannot seem to figure it out. I've tried pivot tables but it's just giving the total sum of Order Total, instead of the Order Total based on unique Order IDs. This would be easy to do in a database, but I need an Excel solution. Any help is appreciated!

Order Id Order Total
3203768 9.95
3203769 98.95
3203770 125
3203771 63.12
3203771 63.12
3203772 164.95
3203773 101.7
3203774 67.04
3203774 67.04
3203774 67.04
3203775 29.95
3203776 119.99
3203777 178.95
3203778 99.95
3203779 79.16
3203781 248.95
3203782 164.95
3203783 498.95
3203784 79.95
3203785 94.32
3203785 94.32

Thanks for the response. I did try that but it doesn't sum the values for only the unique orders. For example, order ID 3203771 has an order total of 63.12 but in the pivot table the order total is summed as 126.24.

Thanks for the response Glenn. Column E in your spreadsheet does get the unique order IDs, but the sum isn't based off the unique order IDs. For example, order ID 3203771 has an order total of 63.12 but in column F the order total is summed as 126.24.

Looks like I made a duplicate post (I kept getting errors when trying to post originally). Sorry about that! Not sure if there's a way to mark something as duplicate and point to only one?

order-totals-need-unique.xlsx
Here's an example file.

Originally Posted by NeedForExcel

It is right!

3203771 has 2 entries of 63.12 (Rows 5 & 6).. 63.12+63.12 = 126.24, which is being shown on the Pivot Table..

Apologies if I'm not being clear. 3203771 is listed twice because that order happened to have two items in the order with a total of 63.12. The unique total for this order is 63.12 but it's being listed twice. Summing the order totals I this way still includes duplicate order IDs but I need the order totals of all unique order IDs.

Awesome, that seems to have done it! I tried it with another order that was listed 7x with an order total of 1,099.75 (not in the example data set I provided) and it's summing the orders correctly.
I knew it'd be something simple! thanks!!