+ Reply to Thread
Results 1 to 4 of 4

sum of inputs and outputs for products with same code?

  1. #1
    Registered User
    Join Date
    07-14-2012
    Location
    tehran,IRAN
    MS-Off Ver
    Excel 2010
    Posts
    15

    sum of inputs and outputs for products with same code?

    I want to sum of inputs and outputs for products with same code?
    how to do it?
    (Result that I want in Table 2)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Re: sum of inputs and outputs for products with same code?

    I think I understand. See attached.
    Attached Files Attached Files
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  3. #3
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: sum of inputs and outputs for products with same code?

    Hi

    Cell M3 =SUMIF($C$3:$C$32,$L3,$D$3:$D$32) Then copy down.
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: sum of inputs and outputs for products with same code?

    or 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.

+ 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