+ Reply to Thread
Results 1 to 6 of 6

Percentage Completion Bar Formula not working

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Percentage Completion Bar Formula not working

    Hi All,

    I am really new with excel, especially when creating formulas.

    Basically, there are three tabs in the Excel spreadsheet (Project Overview, Windows 7 Rollout and HR Activ Absence).

    Whenever we have a new project, they need to add their new project in the project overview. Once it is done, they need to create a new tab with different milestones. When one of the milestones is complete, the percentage will go up.

    If you look at HR Activ Absence tab, it is fine. Whenever you complete a milestone, the percentage will go up.

    However, if you go to Windows 7 tab, the percentage doesn't go up. I think there's a problem with the percentage formula and also the percentage bar.

    The excel spreadsheet is in the attachment. If you cannnot access, please let me know.
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Percentage Completion Bar Formula not working

    Hi Chris,

    Welcome to the forum.
    In Windows 7 Rollout, tab you do not have any project completed i.e., the tick marks are missing .. Also, I believe if you apply the sumif function without table reference, you'll get to know the problem there. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Percentage Completion Bar Formula not working

    Hi Dilipandey,

    Thank you for getting back to me. Yes, i have applied the tick marks but the percentage still doesn't change. I just put "1" in the done column, and it is then changed to complete. Unfortunately, It is still 0%. It doesn't go up even when the milestones are completed. You're probably correct about the table reference. Sorry, i am still very new with the sumif function. Can you tell me what the formula should look like?

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Percentage Completion Bar Formula not working

    Okay.. try using the below formula:-


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See the attached file.. thanks.
    Project Milestones Tracking V.1.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    10-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Percentage Completion Bar Formula not working

    Thank you so much! It works perfectly. Just one more question. Can you tell me what i need to change in the bar. Next to the percentage, you will see the bar percentage as well.

    =REPT("|",Projects[[ ]]*175)

    Thanks,
    Chris

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Percentage Completion Bar Formula not working

    ok.. to achieve that just give the reference to the yellow cell :-

    =REPT("|",H5*175)

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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