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

1. ## 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!

2. ## 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.

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.

4. ## 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.

5. ## 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. ## Re: Formula to show percentage of cells in each segment in custom formatted cells

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