+ Reply to Thread
Results 1 to 4 of 4

Total Item number by number and cost seperatly

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    139

    Total Item number by number and cost seperatly

    I would like to see if anybody could help me on this. I have a work book i am just starting to work on which I want to add up the total cost of each item number and assign it to cell H4(the orange cell. I want the item number to go into G4(Blue cell) My problem is that people can add orders to this worksheet and I wand to be able to separate out item numbers and totals for each. I have uploaded a workbook and there is an example to show what I would like. I need this to be dynamic as they add to this all day. Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Total Item number by number and cost seperatly

    I should solve it this way (with an pivot table).

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Total Item number by number and cost seperatly

    see if this will work

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  4. #4
    Forum Contributor
    Join Date
    12-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: Total Item number by number and cost seperatly

    thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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