+ Reply to Thread
Results 1 to 4 of 4

I'm looking to add up unique values in a column

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Edmonton
    MS-Off Ver
    Excel 2013
    Posts
    17

    I'm looking to add up unique values in a column

    Hello...A long time lurker, I can't tell you how many times I've had a problem solved by searching through here. I've found simular questions, but I can't make a solution work.

    What I am trying to do is add up all of the sales for each customer in a spread sheet.

    Sales Order# Customer $
    1 CustomerA $100
    2 CustomerB $10
    3 CustomerA $50
    4 CustomerA $75
    5 CustomerC $30

    What I would like it to consolidate each customer and show me:
    CustomerA $225
    CustomerB $10
    CustomerC $30

    This is a large spread sheet with 1000's of customers and about 50,000 transactions.

    Thanks for your help!

    Eric

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: I'm looking to add up unique values in a column

    Pivot Table would be the easiest way to do this...

    - Moo

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: I'm looking to add up unique values in a column

    Here's an example of one that would do what you want... (see attached workbook)

    - Moo
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-14-2012
    Location
    Edmonton
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: I'm looking to add up unique values in a column

    That was so easy I'm almost embarrassed!

    Thanks!

+ 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] counting unique values in col A against unique value in column B
    By greyscale in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2013, 08:43 AM
  2. Replies: 2
    Last Post: 02-13-2013, 03:14 PM
  3. [SOLVED] Pick unique values in column A and display the corresponding values from column B & C
    By nostra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-17-2013, 01:51 AM
  4. Count Unique Values In One Column Basis Unique Values in Another Column
    By shez_raz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2012, 01:55 AM
  5. create list of unique values from a column with repeated values?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 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