+ Reply to Thread
Results 1 to 3 of 3

Lookup combined with sum formula

  1. #1
    Registered User
    Join Date
    07-12-2015
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    18

    Lookup combined with sum formula

    Hi,

    First of all I want to say thank you for a great forum. I have learned quite a bit in the last few days just by reading on here and imitating Formulas.

    I am trying to do a simple lookup formula combined with SUM and need your help.

    Please take a look at my attached Excel-file. I have one sheet called "Division" that lists three different groups. Each of the groups have a certain sheet.

    In the B column in the Division 1 sheet I need a lookup formula that go to the correct sheet, get the values in B2 and C2 and sum them.

    Appreciate your help.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,107

    Re: Lookup combined with sum formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Lookup combined with sum formula

    I should re-arange the data.

    After that a pivot table to analyse the data.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add 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. seeking a combined 'index' / vertical lookup with two citeria - formula
    By nielsb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-2015, 04:54 PM
  2. Combined H & V Lookup?
    By nac1987 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-29-2014, 09:07 PM
  3. [SOLVED] Need formula to lookup minimum/maximum value combined with multiple conditions
    By VincentNL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2014, 09:27 AM
  4. Combined IF and LOOKUP functions - Help please!
    By DaithiMacGiolla in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-13-2014, 11:20 AM
  5. LOOKUP and IF Combined
    By adz59shadow in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-30-2013, 09:08 PM
  6. V-Lookup - Combined Lookup Values (2+)
    By Kolin in forum Excel General
    Replies: 2
    Last Post: 07-22-2010, 02:36 PM
  7. Array formula combined with Lookup
    By Kevin Gallagher in forum Excel General
    Replies: 9
    Last Post: 03-02-2006, 02:55 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