+ Reply to Thread
Results 1 to 3 of 3

Sum value in a third column if columns 1 and 2 contain same value

Hybrid View

  1. #1
    Registered User
    Join Date
    06-19-2015
    Location
    edmonton
    MS-Off Ver
    2010
    Posts
    16

    Angry Sum value in a third column if columns 1 and 2 contain same value

    Hey there,

    I need help with a Sumifs and/or vlookup formula.

    Was wondering how to sum a corresponding 3rd column value if 2 other columns contain the same values, but not on the same row for instance.

    Col A ... Col F ... Col H
    123456 777777 21
    000000 888888 82
    777777 444444 99
    989898 787878 101
    787878 222222 72


    My formula would at this point spit out 122.. which is 21+101 because 787878 and 777777 are the only 2 matching cells and 21 and 101 are beside the match that is in column f.

    To make this more complicated they aren't beside each other and I am linking the formula to another sheet.

    Thanks

    Travis

  2. #2
    Registered User
    Join Date
    06-19-2015
    Location
    edmonton
    MS-Off Ver
    2010
    Posts
    16

    Re: Sum value in a third column if columns 1 and 2 contain same value

    sorry for the lack of excel file but I believe I explained my problem, thanks

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Sum value in a third column if columns 1 and 2 contain same value

    Assuming your sample data lies in the range A2:C6, then try this......

    =SUMPRODUCT((ISNUMBER(MATCH(B2:B6,A2:A6,0)))*C2:C6)
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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. Compare multiple columns (column A,column B,Column C) and return value (Column D)
    By john008 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2015, 08:24 AM
  2. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  3. Replies: 0
    Last Post: 01-14-2014, 06:35 PM
  4. [SOLVED] If Column A matches Column E enter Columns F & G into Columns B & C
    By rkobeyer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2013, 01:12 AM
  5. MAcro to - copy, transpose, text to columns, remove column A, combine all columns in 1
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-07-2013, 08:48 AM
  6. Replies: 1
    Last Post: 11-06-2012, 07:07 PM
  7. [SOLVED] Combine multiple columns into two long columns, Repeating rows in first column
    By anasab@gmail.com in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 12:13 PM

Tags for this Thread

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