+ Reply to Thread
Results 1 to 6 of 6

Lookup from a different column to return sum value if criteria is met.

  1. #1
    Registered User
    Join Date
    10-24-2010
    Location
    Brunei
    MS-Off Ver
    Excel 2007
    Posts
    13

    Lookup from a different column to return sum value if criteria is met.

    hi all,

    need help for lookup formula from a column to give a summary of the person who made a sale at the specific price range.

    attached a sample file for reference.

    thanks for your help in advance.

    pang.

    try one.xlsx

  2. #2
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Lookup from a different column to return sum value if criteria is met.

    Bit more detail where on the sheet your wanting the information to show up?

    nevermind, looked at all the sheet now :P
    Last edited by AYData; 08-19-2013 at 12:23 AM. Reason: corrected myself

  3. #3
    Registered User
    Join Date
    10-24-2010
    Location
    Brunei
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Lookup from a different column to return sum value if criteria is met.

    hi,

    on the summary side. in the grey coloured box. data is entered on the orange coloured cells.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: Lookup from a different column to return sum value if criteria is met.

    This will give you what you want for the 1st small table...

    =SUMIFS($F$9:$F$60,$C$9:$C$60,$W9,$I$9:$I$60,MID(Z$7,SEARCH("$",Z$7,1)+1,5)*1)

    and use this for the 2nd small table...
    =SUMIFS($F$9:$F$60,$M$9:$M$60,$W9,$S$9:$S$60,MID(AF$7,SEARCH("$",AF$7,1)+1,5)*1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    10-24-2010
    Location
    Brunei
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Lookup from a different column to return sum value if criteria is met.

    thanks Fdibbins.

    that formula worked great.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,789

    Re: Lookup from a different column to return sum value if criteria is met.

    Happy to help and thanks for the feedback

+ 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. Replies: 7
    Last Post: 08-04-2013, 03:41 PM
  2. Replies: 4
    Last Post: 03-13-2013, 12:38 PM
  3. [SOLVED] Lookup value and match with 2 criteria and return another value
    By AlphaCraig in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2012, 07:35 PM
  4. [SOLVED] Mutliple criteria lookup to return a value
    By JIMH1980 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-18-2012, 08:00 AM
  5. Replies: 3
    Last Post: 11-03-2010, 04:05 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