+ Reply to Thread
Results 1 to 4 of 4

Percentage from each day into a weekly summary

  1. #1
    Forum Contributor
    Join Date
    02-03-2018
    Location
    Edinburgh
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    155

    Percentage from each day into a weekly summary

    I am trying to show the percentage of deliveries on time in a weekly summary.

    I am picking up the total from each day using = then the cell on the tab for each day of the week.

    The cell for each day displays percentage fine, 80% etc but the cells in the weekly summary display #VALUE!

    I have tried to change the cells in the row to percentage etc but nothing seems to work.

    Any ideas please??

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Percentage from each day into a weekly summary

    Attach a sample workbook showing the error.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Forum Contributor
    Join Date
    02-03-2018
    Location
    Edinburgh
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    155

    Re: Percentage from each day into a weekly summary

    Worked it out, the cursed merged cell!!!! Grrrrrrrr! Thanks Kersplash.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,019

    Re: Percentage from each day into a weekly summary

    Thats why we always advise against using merged cells - they cause all sorts of problems with formulas
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] 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
  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. 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
  4. 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
  5. [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
  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