+ Reply to Thread
Results 1 to 6 of 6

weekly summary

  1. #1
    Registered User
    Join Date
    11-05-2019
    Location
    usa
    MS-Off Ver
    2013
    Posts
    7

    weekly summary

    Hello All,

    Sheet1 -Daily ( Tab->Jan-20)
    Sheet 2- Weekly ( Sat - Fri)

    i want sheet 2 for the whole year weekly summary which will will pull data from daily sheet( Jan-20).
    I just want to pull the data of each company for each day and date and take it to the summary sheet.

    It seems like very frustrating because if i try date or day look up but they are merged it only pulls data from the 1st column of row .

    I have attached an example i hope you will understand what i`m trying to say -
    Thanks.
    Attached Files Attached Files
    Last edited by tauceph; 11-05-2019 at 12:22 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,006

    Re: I need help making weekly summary

    I am confused...

    Please populate the sheet with some manually calculated expected results AND tell us which is the raw data and which is the expected results...
    Glenn



  3. #3
    Registered User
    Join Date
    11-05-2019
    Location
    usa
    MS-Off Ver
    2013
    Posts
    7

    Re: weekly summary

    Thanks Glen

    i attached another file highlighted the data in both sheet .

    Jan-20 is the manually working sheet and sheet weekly will pull the data for the same date and day from that jan-20 sheet .

    I need to use a function instead of connecting both sheet with the reference.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,006

    Re: weekly summary

    Each column form AW to BB has a slightly different formula. Here's one:

    =INDEX('Jan-20'!$G$6:$FE$6,,MATCH(AW$4,'Jan-20'!$G$2:$FE$2,0)+ROWS($1:1)-1)

    they're all similar, though. Then select ALL cells: AW6:BE9 (I do mean BE, not BB), copy and paste into BF6, BO6, etc.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-05-2019
    Location
    usa
    MS-Off Ver
    2013
    Posts
    7

    Re: weekly summary

    Thanks Glen you are the man . Appreciated.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,006

    Re: weekly summary

    ... and you are welcome.

+ 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] Percentage from each day into a weekly summary
    By GHI1968 in forum Excel General
    Replies: 3
    Last Post: 07-10-2018, 11:37 PM
  2. [SOLVED] Look up and sum daily data to weekly summary
    By Spamanda in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-11-2016, 01:27 PM
  3. [SOLVED] Converting daily data into weekly and making the weekly number a cumulative return
    By Duchess1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2015, 10:23 AM
  4. How to get summary/count of task on weekly basis
    By SJ73 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2013, 06:20 AM
  5. Need to add up data for weekly summary. SUMPRODUCT
    By ARN in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2013, 04:29 PM
  6. Excel 2007 : Help with monthly weekly summary
    By kakashi07 in forum Excel General
    Replies: 2
    Last Post: 03-14-2012, 10:54 AM
  7. Display a weekly summary
    By markag in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2006, 04:28 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