+ Reply to Thread
Results 1 to 2 of 2

SUMIF with VLOOKUP combination

  1. #1
    Registered User
    Join Date
    07-20-2016
    Location
    Abu Dhabi, U.A.E.
    MS-Off Ver
    2013
    Posts
    1

    SUMIF with VLOOKUP combination

    I need to take the sum of value 2 devided by sum of value 1 only if the mapping has "Y" for instrument using vlookup formula.



    Instrument Value 1 Value 2 Mapping
    XS1117297 2,000,000.00 1,915,000
    XS1117297 -500,000.00 -478,125 Y
    XS1117297 -200,000.00 -192,000 Y
    XS1017435 -1,254,000.00 -1,279,080
    XS1017435 250,000.00 261,250
    XS1017435 -250,000.00 -261,488 y
    XS1017435 250,000.00 260,325 y
    XS1017435 -250,000.00 -260,250 y

    Expected result should be as follows.

    XS1117297 0.957321429
    XS1017435 1.04565

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: SUMIF with VLOOKUP combination

    Assuming your data shown above starts in A1 then
    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation

+ 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 and Sumif combination
    By savetrees in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-08-2014, 06:42 AM
  2. Sumif Vlookup combination?
    By cw1628 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-05-2014, 05:36 PM
  3. SumIf combination?
    By cw1628 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2014, 05:43 PM
  4. Vlookup and Sumif Combination
    By TC16 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-29-2013, 09:11 AM
  5. Desparate SUMIF and VLOOKUP combination?
    By vmansson in forum Excel General
    Replies: 2
    Last Post: 07-31-2012, 06:54 AM
  6. SUMIF - VLOOKUP Combination
    By Fraser in forum Excel General
    Replies: 7
    Last Post: 10-27-2009, 12:34 PM
  7. Sumif and Vlookup combination?
    By Rhapsodie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2008, 12:26 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