+ Reply to Thread
Results 1 to 5 of 5

sumproduct with multi lookup value

  1. #1
    Registered User
    Join Date
    04-23-2018
    Location
    Hong Kong
    MS-Off Ver
    2016
    Posts
    2

    sumproduct with multi lookup value

    Excel.png

    Can i use sumproduct to get the total mark? how?

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365 Version 2202
    Posts
    6,137

    Re: sumproduct with multi lookup value

    If Total Mark should be the sum of all of the marks, try this in G2:

    =SUMPRODUCT((B2:F2=A$11:A$17)*B$11:B$17)

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,634

    Re: sumproduct with multi lookup value

    Try in G2:

    Please Login or Register  to view this content.
    Drag down

  4. #4
    Registered User
    Join Date
    04-23-2018
    Location
    Hong Kong
    MS-Off Ver
    2016
    Posts
    2

    Re: sumproduct with multi lookup value

    Thanks a lot. It works

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365 Version 2202
    Posts
    6,137

    Re: sumproduct with multi lookup value

    You're welcome. Glad we could help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Using SUMPRODUCT in place of COUNTIFS for multi column lookup
    By RoundaboutCJP in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-12-2018, 10:50 AM
  2. Multi criteria lookup with the ''=lookup' formula
    By Ronnet2 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-17-2015, 07:12 AM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. [SOLVED] Data Validation, Lookup, multi lookup, referancing and other.
    By archasem in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-04-2013, 10:50 AM
  5. [SOLVED] multi drop down list with multi-lookup
    By civileng12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2012, 06:50 PM
  6. Lookup multi columns w/ multi answers
    By dec671 in forum Excel General
    Replies: 1
    Last Post: 01-28-2010, 04:48 PM
  7. SUMPRODUCT + multi conditions
    By BernzG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2006, 09:30 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