+ Reply to Thread
Results 1 to 5 of 5

Sum duplicate values in column

  1. #1
    Registered User
    Join Date
    02-16-2005
    Posts
    10

    Exclamation Sum duplicate values in column

    Hi,

    I need to find duplicate values in a column and sum its lookup value on the right column. These are the data:

    DEFECT WW1
    Tombstoned 9
    Excess solder 8
    Wrong Orien't label 7
    Wrong Orien't label 10
    Damage Connector 6
    Damage IC's 2
    Reflow 45
    Bridging 26
    Reflow 6
    Comp Oxicide 34
    Connector damage 5
    Damage terminal 1
    Excess solder 4
    Burn tantalum 2
    Damage IC's 0

    Since column ("DEFECT") has duplicate values, i need to find those values and sum its corresponding ("WW1") values on the right. Those totals will be displayed in another column with its defects . Is it clear? Thanks.

  2. #2
    Forum Contributor
    Join Date
    09-05-2004
    Location
    Melbourne
    Posts
    193
    If, for example, you use cell D2 as the Defect to count cell and your data is in columns A:B then use this formula.

    =SUMPRODUCT(--(A2:A100=D2),B2:B100)

    Cheers

    P.S - if you need to count all Defects then repost as their are ways of extracting data without duplicating.

  3. #3
    Registered User
    Join Date
    02-16-2005
    Posts
    10
    ok...suppose that the defects are in column K and the number of defects are in L. I need to sum all the same type of defects and display in another cell. Can i use the same method to do this?

  4. #4
    Registered User
    Join Date
    02-16-2005
    Posts
    10
    Thanks a lot..i could do it. I still have another problem..how do i refer to the defects when the value is sumed?

  5. #5
    Forum Contributor
    Join Date
    09-05-2004
    Location
    Melbourne
    Posts
    193
    Can you elaborate a little more on this. In what way do you need to refer to the defects?

+ 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