+ Reply to Thread
Results 1 to 4 of 4

Delivery Report Summary...Monthly total sheet on 4 individual weekly sheets

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Delivery Report Summary...Monthly total sheet on 4 individual weekly sheets

    We have a weekly "On-Time" report that shows early, late, on time, or no data. Each week has a total percentage of early, late, on time, or no data deliveries. I now need a monthly total on a seperate worksheet, but for some reason I can not get the percentages to total correctly. I am attaching the spreadsheet.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Delivery Report Summary...Monthly total sheet on 4 individual weekly sheets

    Hi,

    You just needed to divide the sums by 4

    I hope this helps

  3. #3
    Registered User
    Join Date
    04-10-2013
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Delivery Report Summary...Monthly total sheet on 4 individual weekly sheets

    Of course!

    Thank you so much

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Delivery Report Summary...Monthly total sheet on 4 individual weekly sheets

    No worries

    I should also let you know, some of the formulas on the weekly worksheets were counting row 1 also, so your total of percentages was not adding up to 100% there either. This has been fixed in my previous attachment.

    Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks

+ 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. Replies: 1
    Last Post: 08-15-2013, 02:15 PM
  2. [SOLVED] Need Macro to compile data from "Weekly" sheets and sum up into "Monthly" summary sheet
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 07:25 PM
  3. [SOLVED] Monthly Summary Based on Weekly Dates
    By thisisgerald in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-14-2012, 04:49 AM
  4. Excel 2007 : Help with monthly weekly summary
    By kakashi07 in forum Excel General
    Replies: 2
    Last Post: 03-14-2012, 10:54 AM
  5. Need to save Running Total and generate Weekly and Monthly Report based on date
    By soready42012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-04-2012, 09:10 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