+ Reply to Thread
Results 1 to 4 of 4

SUM VLOOKUP which calculates multiple values across multiple sheets

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    68

    SUM VLOOKUP which calculates multiple values across multiple sheets

    Hi All

    I have created a workbook which is to act as a timesheet for a working week. Each Day has its own tab, Named Mon, Tues,Wed, Thu,Fri and there is a summary tab which is designed to add all the values for a particular Item for each day and give a total for the week.

    The items on each tab are listed in Cell A2 to Cell A27. (Note there will be dublicte items and all values need added)
    The total value for each item is listed in Cell H2 to Cell H27

    In the Summary tab the item will be displayed in Cell E2, I am writing the formula in Cell F2. I'm guessing its some sort of INDEX MATCH VLOOKUP but I haven't come close to solving.

    I have attached the Workbook, which might help.

    Many thanks
    Greg
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: SUM VLOOKUP which calculates multiple values across multiple sheets

    I suggest you use 1 tab for all data and add a column to determine the day (the work is done).

    After that a pivot table.

    See the attached file.
    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.

  3. #3
    Registered User
    Join Date
    02-29-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    68

    Re: SUM VLOOKUP which calculates multiple values across multiple sheets

    Mmm pivot table maybe is the most logical approach. Certainly gives me what I need. Thank you very much.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: SUM VLOOKUP which calculates multiple values across multiple sheets

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ 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. Macro using VLOOKUP with multiple matches between multiple sheets
    By tripathy69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2014, 10:14 AM
  2. Replies: 2
    Last Post: 10-22-2013, 12:44 PM
  3. Vlookup (or index/match) with multiple criteria over multiple sheets
    By Groovicles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2013, 01:56 PM
  4. Vlookup function to return multiple values from multiple sheets
    By bsamant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 11:31 AM
  5. Macro using VLOOKUP with multiple matches between multiple sheets
    By Derrek0204 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2011, 06:20 PM
  6. Sum of multiple values from multiple conditions across multiple sheets
    By ride_op in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-19-2011, 01:27 AM
  7. Vlookup- multiple corresponding values (2 separate sheets)
    By mitelkm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2008, 12:50 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