Results 1 to 3 of 3

sumifs function exclude duplicate in one of the column

Threaded 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

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