+ Reply to Thread
Results 1 to 3 of 3

sumifs function exclude duplicate in one of the column

Hybrid View

  1. #1
    Registered User
    Join Date
    03-02-2014
    Location
    uae
    MS-Off Ver
    Excel 2010
    Posts
    3

    sumifs function exclude duplicate in one of the column

    Please hellp in finding sumifs formula which exclude duplicate value in one of the column.

    i want to sum 'voucher amount' (column G) subject to multiple conditions but it it should exclude duplicate document no in column B. Attached sample sheet.


    Txn Code Doc No Doc Date Salesman Code Item Code Voucher No Voucher Amt Voucher Date ACPCATGNAME DIVNCODE
    CRINV 2016000888 17-JAN-16 10072 100400600044 PDCRV-2015000887 29000 23-NOV-15 Commercial 10
    CRINV 2016000887 17-JAN-16 10072 100400600119 PDCRV-2015000887 27720 23-NOV-15 Commercial 10
    CRINV 2016000888 17-JAN-16 10072 100400600119 PDCRV-2015000887 29000 23-NOV-15 Commercial 10
    CRINV 2016000884 17-JAN-16 10072 100200200006 PDCRV-2015000613 69700 31-AUG-15 Commercial 10

    thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: sumifs function exclude duplicate in one of the column

    EDIT:

    Attach a sample workbook that is clear and concise. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Last edited by mikeTRON; 08-03-2016 at 11:23 AM.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    03-02-2014
    Location
    uae
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: sumifs function exclude duplicate in one of the column

    i have uploaded another sample with before and after result.

    basically i want to sum receipt amount for salesman 10072 subject to condition that receipt is through PDCRV and for div 10. But i want to exclude duplicate invoice value. THanks
    Attached Files Attached Files

+ 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. SUMIFS and exclude Duplicates
    By Mark929 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2015, 01:06 PM
  2. Sumifs exclude cells that are hidden with data filter
    By rhyan66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2013, 10:16 AM
  3. SUMIFS and exclude Duplicates with a table reference
    By GOQC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-06-2013, 01:24 PM
  4. Replies: 1
    Last Post: 03-09-2013, 06:26 AM
  5. Formula to Exclude Duplicate Values
    By jjcgirl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2013, 11:43 AM
  6. Sum Mulitple Column based on the multiple Conditions using sumifs function
    By JEETKAMALARORA in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-20-2012, 03:24 AM
  7. Replies: 3
    Last Post: 11-12-2009, 04:42 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