+ Reply to Thread
Results 1 to 6 of 6

Formula to show percentage of cells in each segment in custom formatted cells

  1. #1
    Registered User
    Join Date
    08-03-2016
    Location
    Amsterdam
    MS-Off Ver
    2011
    Posts
    3

    Formula to show percentage of cells in each segment in custom formatted cells

    I'm trying to show the percentage of cells that are in each segment of a custom formatted column.

    The column represents the status of completion of a certain task in a project.
    Values are =0; =>1 ; =>50; =>99

    Overdue =0
    Not yet started =>1
    In progress =>50
    Complete =>99

    Screen Shot 2016-08-03 at 16.12.45.png

    I would ultimately like the % of each custom formatted segment (% of black, red, yellow vs green dots) to be represented in a pie chart on a dashboard. I have already created the fields linking to the pie chart.
    What I need is to find a way to calculate the % complete tasks, in progress tasks, not yet started tasks and overdue tasks to link to the pie chart.



    The values in percentage of tasks table are dummies.

    Your help would be greatly appreciated!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by newbie_Lau; 08-03-2016 at 11:08 AM. Reason: corrected image

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Formula to show percentage of cells in each segment in custom formatted cells

    Welcome to the forum.


    Attach a sample workbook instead of a picture.
    Make sure there is just enough data to demonstrate your need.
    Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.
    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    08-03-2016
    Location
    Amsterdam
    MS-Off Ver
    2011
    Posts
    3

    Re: Formula to show percentage of cells in each segment in custom formatted cells

    Thank you! I have attached the sample workbook to the original post, as well as to this reply.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Formula to show percentage of cells in each segment in custom formatted cells

    So the formula you want is COUNTIF

    See attached.
    Let me know if you have any questions.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-03-2016
    Location
    Amsterdam
    MS-Off Ver
    2011
    Posts
    3

    Re: Formula to show percentage of cells in each segment in custom formatted cells

    Brilliant! Thanks!!

    Thank you MikeTRON (completed - green)
    Continue learning on ExcelForum (in progress - yellow)

    Time to eat the peanut butter sandwich!

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Formula to show percentage of cells in each segment in custom formatted cells

    Glad I could help

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. 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. [SOLVED] Count Custom Number Formatted Cells
    By SamCV in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2015, 10:28 AM
  2. Replies: 4
    Last Post: 12-19-2014, 06:49 AM
  3. [SOLVED] Conditional formatting for percentage formatted cells
    By boomboomblock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2013, 07:46 AM
  4. Replies: 0
    Last Post: 09-11-2012, 07:09 AM
  5. Replies: 2
    Last Post: 05-02-2012, 08:38 PM
  6. Replies: 1
    Last Post: 04-18-2006, 01:35 PM
  7. Custom formula to show each item as percentage of grand total?
    By RoryMacLeod in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-07-2005, 10:49 AM

Tags for this Thread

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