+ Reply to Thread
Results 1 to 7 of 7

Calculate Weekly totals in separate sheet, from daily totals

  1. #1
    Registered User
    Join Date
    01-09-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    4

    Calculate Weekly totals in separate sheet, from daily totals

    I have the following issue

    spreadsheetissue.PNG

    I want to calculate weekly totals of the above into a separate sheet (below)

    spreadsheetissue2.PNG

    I want to be able to drag the formula across so it automatically calculates amounts for one week. As you can see in Column L & M I have done this manually but I want to be able to drag it across and for it to calculate.

    I have tried Offset Sums and I can't get it to work correctly.

    Any help would be much appreciated.

    Thanks in Advanced
    Attached Images Attached Images

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculate Weekly totals in separate sheet, from daily totals

    Hi and welcome to the forum.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Calculate Weekly totals in separate sheet, from daily totals

    Have you tried SUMIFS? See attachment
    Attached Files Attached Files
    Quang PT

  4. #4
    Registered User
    Join Date
    01-09-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculate Weekly totals in separate sheet, from daily totals

    Thanks for your help Quang,

    The IF statement you used only works for the first two weeks for some reason, and I can't figure out why, even on your spreadsheet?

    Would do you have a solution for this?

    Thanks

  5. #5
    Registered User
    Join Date
    01-09-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculate Weekly totals in separate sheet, from daily totals

    Re: Calculate Weekly totals in separate sheet, from daily totals
    Thanks for your help Quang,

    The IF statement you used only works for the first two weeks for some reason, and I can't figure out why, even on your spreadsheet?

    Would do you have a solution for this?

    Thanks

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Calculate Weekly totals in separate sheet, from daily totals

    Try to expand the range to cover all data columns?

    =SUMIFS(Data!$M2:$AX2,Data!$M$1:$AX$1,">="&L$1,Data!$M$1:$AX$1,"<"&M$1)

  7. #7
    Registered User
    Join Date
    01-09-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    4

    Re: Calculate Weekly totals in separate sheet, from daily totals

    Thank you so much!

    That worked Perfectly

+ 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. summing daily weekly & monthly totals
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-10-2014, 04:49 PM
  2. MAX daily (or weekly) totals
    By collegeitdept in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-18-2014, 04:42 PM
  3. [SOLVED] Sum workday totals on one sheet to weekly totals on another
    By BryanD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2013, 10:08 AM
  4. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  5. Calculate Totals weekly and Monthly from daily Figures
    By mfjanoo in forum Excel General
    Replies: 3
    Last Post: 03-05-2012, 03:06 PM
  6. logging labor hours: daily, weekly and overall totals
    By revelever in forum Excel General
    Replies: 1
    Last Post: 08-19-2011, 04:27 PM
  7. Collecting weekly and monthly totals from daily data
    By Kasper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-12-2006, 04:10 PM
  8. How can I calculate weekly totals of daily data in Excel
    By BarrySandell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-08-2005, 12: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