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!

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.

So the formula you want is COUNTIF

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

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.