+ Reply to Thread
Results 1 to 7 of 7

Look up and sum daily data to weekly summary

  1. #1
    Registered User
    Join Date
    10-11-2016
    Location
    Cincinnati, Ohio
    MS-Off Ver
    2010
    Posts
    6

    Look up and sum daily data to weekly summary

    My predecessor has been manually entering sum formulas for each expense category in each week. I'd like to use a formula which can be copied across the rows to pull the daily data into a weekly summary. I can't imagine this is too difficult. I'm just don't have enough Excel experience to figure it out.
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Look up and sum daily data to weekly summary

    What specifically you looking for? Those SUM formulae seems OK.

  3. #3
    Registered User
    Join Date
    10-11-2016
    Location
    Cincinnati, Ohio
    MS-Off Ver
    2010
    Posts
    6

    Re: Look up and sum daily data to weekly summary

    Since I have multiple rows of information going across 52 weeks, I'd like to automate the formula so it can be copied to each week without having to enter the specific rows of data to sum for each week.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Look up and sum daily data to weekly summary

    Looks like Pivot Table is what you looking for.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,349

    Re: Look up and sum daily data to weekly summary

    In "Weekly Cash Flows"

    in C5

    =SUMIFS('Daily Cash Flow'!$C:$C,'Daily Cash Flow'!$A:$A,">="&C$2,'Daily Cash Flow'!$A:$A,"<="&C$3)

    In C6

    =SUMIFS('Daily Cash Flow'!$D:$D,'Daily Cash Flow'!$A:$A,">="&C$2,'Daily Cash Flow'!$A:$A,"<="&C$3)*-1

    Copy both across

    Repeat for other entries, changing the first range (highlighted in bold)

  6. #6
    Registered User
    Join Date
    10-11-2016
    Location
    Cincinnati, Ohio
    MS-Off Ver
    2010
    Posts
    6

    Re: Look up and sum daily data to weekly summary

    Perfect! Thank you, Mr. Topley!

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,349

    Re: Look up and sum daily data to weekly summary

    Thank for the feedback and rep.

+ 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. Transfer Daily Data from Daily Staffing Workbooks into a Running Annual Summary Workbook
    By nurseydiamond in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-07-2015, 07:05 PM
  2. [SOLVED] Weekly summary from daily OHLC data
    By macaonghus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-08-2015, 03:59 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. [SOLVED] Formula to Group analytical data imputed daily into daily weekly and monthly analysis.
    By tianasamour in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2015, 06:10 PM
  5. Replies: 1
    Last Post: 04-13-2015, 04:38 PM
  6. Task time tracking with daily and weekly and monthly summary
    By issam.ha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2014, 12:02 PM
  7. Replies: 3
    Last Post: 10-01-2013, 05: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