+ Reply to Thread
Results 1 to 3 of 3

Match multiple criteria in different lines

  1. #1
    Registered User
    Join Date
    03-07-2017
    Location
    Ontario
    MS-Off Ver
    2010
    Posts
    20

    Match multiple criteria in different lines

    Hi;

    Someday I hope I will be able to wrap my head around the match concept but for now I hope the forum comes to my rescue once again. I need to match sales and customer counts based on the terminal name and date. The two sections will eventually be on separate tabs in the same workbook. I have attached a sample sheet.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    6,954

    Re: Match multiple criteria in different lines

    Please try at N3
    =IFERROR(SUMPRODUCT((LOOKUP(ROW($B$3:$B$29),ROW($B$3:$B$29)/($B$3:$B$29<>0))=MATCH($M3,$B:$B,))*($C$3:$C$29=N$2),INDEX($D$3:$E$29,,MOD(COLUMNS($M3:N3),2)+1)),0)

    Custom Format General;; to hide zero
    Attached Files Attached Files

  3. #3
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Essex, UK
    MS-Off Ver
    various
    Posts
    2,575

    Re: Match multiple criteria in different lines

    If you want to keep things simple(r) you need only add a 'key' ... so, using your sample file:

    G3: =LOOKUP(REPT("Z",255),$B$3:$B3)&"^"&$C3
    copied down

    N3: =SUMIF($G:$G,$M3&"^"&N$2,INDEX($D:$E,0,1+(N$1="Head Count")))
    applied to matrix N3:AA16

+ 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. Remove lines based on multiple criteria
    By cmray58 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-20-2018, 12:12 PM
  2. [SOLVED] Sum Multiple Lines based on Multiple Criteria
    By Netsirkf in forum Excel General
    Replies: 5
    Last Post: 10-29-2018, 05:49 AM
  3. Count/Find X on multiple lines w/ multiple criteria
    By artistapart in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2016, 12:55 PM
  4. Match lines with Multiple Specific Criteria
    By stockgoblin42 in forum Excel General
    Replies: 0
    Last Post: 06-15-2016, 11:23 PM
  5. Replies: 3
    Last Post: 08-25-2014, 08:04 PM
  6. Formula to Exclude lines that dont match criteria
    By chrismike in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-27-2013, 07:18 PM
  7. Create multiple lines based upon criteria
    By SystemsAccountant in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-05-2008, 01:14 PM

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