+ Reply to Thread
Results 1 to 2 of 2

Sum of Order Total Based on Unique Order ID

  1. #1
    Registered User
    Join Date
    07-31-2015
    Location
    Detroit
    MS-Off Ver
    2013
    Posts
    8

    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!

    [QUOTE]
    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

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Sum of Order Total Based on Unique Order ID

    Duplicate Post -

    http://www.excelforum.com/excel-form...-order-id.html
    Cheers!
    Deep Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Sum of Order Total Based on Unique Order ID
    By ivdezine in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-31-2015, 08:10 AM
  2. [SOLVED] Highlight cell based on total quantity value based on repeated order numbers
    By PWilson0727 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 02:02 PM
  3. [SOLVED] Find Unique & calculate the Total of Work order
    By abaumgartner in forum Excel General
    Replies: 14
    Last Post: 08-02-2014, 02:38 PM
  4. [SOLVED] Quantity in column D based on order amount of times the order no appears
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2013, 06:48 PM
  5. Replies: 5
    Last Post: 07-22-2013, 05:56 PM
  6. [SOLVED] Probably a SUM formula for order no. to get the total amount of order
    By Konnie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 04:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1