+ Reply to Thread
Results 1 to 5 of 5

Sum of sales per item

  1. #1
    Registered User
    Join Date
    03-01-2015
    Location
    Athens, Greece
    MS-Off Ver
    2013
    Posts
    11

    Post Sum of sales per item

    Hello guys,

    I have items sold per transaction (A: product, B: quantity)

    I need to make a new list with the sum of the items sold per product (E: Product, D: Total Quantity)

    Thank you in advance!

    Filipp

    excelproblem.JPG

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,458

    Re: Sum of sales per item

    If you add headers for the columns you can easily use a Pivot Table to summarize the data
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,458

    Re: Sum of sales per item

    Your layout being perfect for a PT see https://www.contextures.com/CreatePivotTable.html for info if needed

  4. #4
    Registered User
    Join Date
    03-01-2015
    Location
    Athens, Greece
    MS-Off Ver
    2013
    Posts
    11

    Re: Sum of sales per item

    Thank you Pepe Le Mokko!
    It is exactly what I was looking for!

  5. #5
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,458

    Re: Sum of sales per item

    You're welcome
    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Sort Daily Sales Item by VB Code
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2014, 10:34 PM
  2. Replies: 1
    Last Post: 11-19-2013, 12:52 PM
  3. Replies: 2
    Last Post: 09-17-2013, 10:09 AM
  4. [SOLVED] Calculating sales with respect to item and in a particular month
    By peaceracer in forum Excel General
    Replies: 12
    Last Post: 07-19-2012, 03:23 AM
  5. POS - Delete Inventory based on Item Numbers on Sales Screen.
    By retrotime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2011, 06:17 AM
  6. Match Item Number to Sales Data on Another Sheet?
    By schweitzerc in forum Excel General
    Replies: 7
    Last Post: 06-14-2010, 02:01 PM

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