+ Reply to Thread
Results 1 to 3 of 3

Test Single Column against Multiple Columns then return Sum result

  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    Yorktown, VA
    MS-Off Ver
    15.34
    Posts
    6

    Test Single Column against Multiple Columns then return Sum result

    I'm trying to compare a range of cells in one column against a range of cells in 3 other separate columns. If there is a match then provide sum of an additional column.

    The logic would read as follows:

    If any cell in range A1:A30 equals any cell in B1:B30, C1:C30 or D1:D30 then return sum of E1:E30.

    If it matters the A, B, C & D columns would contain both a number and text (i.e. 130A, 156B, etc.), while E is strictly numbers.

    Any help is greatly appreciated!!! Been racking my brain on this for a few weeks now.

    Thanks in advance!!

  2. #2
    Registered User
    Join Date
    06-02-2017
    Location
    Yorktown, VA
    MS-Off Ver
    15.34
    Posts
    6

    Re: Test Single Column against Multiple Columns then return Sum result

    Additionally... Columns B, C & D have the same column name, so essentially a named range incorporating all three with that name could be utilized (if even possible )

  3. #3
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Test Single Column against Multiple Columns then return Sum result

    Try this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ 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. [SOLVED] vLookup multiple values separated by ";" in single cell / return result in single cell
    By Tunesmith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2015, 12:02 PM
  2. Return multiple columns and rows into single column
    By decarvalho.charles in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 07:25 AM
  3. Searching a table for multiple criteria to return single result
    By erice in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2014, 09:53 AM
  4. [SOLVED] VLOOKUP to search multiple columns and return value from single column
    By BBExcelusr in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 08-01-2012, 01:12 PM
  5. Replies: 2
    Last Post: 05-03-2012, 01:18 PM
  6. Indexing multiple columns to return a result from a separate column
    By janjan_376 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2009, 03:14 PM
  7. return single result from multiple rows
    By tracemul7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2008, 02:04 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