+ Reply to Thread
Results 1 to 3 of 3

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

  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......

    Please Login or Register  to view this content.
    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