+ Reply to Thread
Results 1 to 2 of 2

help with duplicate sumproduct formula

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    help with duplicate sumproduct formula

    hello. can sOMEONe help me understand this sumproduct formula that looks for duplicates in different columns? Gracias. I don't understand what it doing. What is the need for sumproduct?

    =SUMPRODUCT((COUNTIF(A2:A8,B2:B8)=0)*(B2:B8<>""))

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,616

    Re: help with duplicate sumproduct formula

    Sumproduct is here used to sum each B column item, which is not listed in column A, so it is equivalent to

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ 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. Replies: 10
    Last Post: 12-16-2015, 03:16 PM
  2. SumProduct on Duplicate values
    By raja_puligadda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2015, 04:29 AM
  3. Replies: 9
    Last Post: 12-03-2014, 04:47 AM
  4. [SOLVED] Using SUMPRODUCT to sum duplicate scores with same criteria
    By JoeJaycee in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-17-2012, 06:27 PM
  5. Exclude duplicate values from out of a calculating a sumproduct
    By Alan Casey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2012, 04:29 PM
  6. Excel 2007 : SUMPRODUCT with duplicate values
    By SEHRA in forum Excel General
    Replies: 2
    Last Post: 06-25-2011, 01:13 PM
  7. SumProduct/CountIf/Duplicate
    By ExcelNewby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2007, 09:39 AM

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