✭✭✭✭

Hello!

I'm attempting embed a tracker for understanding progress completion by different categories within a project plan. See screenshot below!

This formula is supposed to count if a task is checked off within the hub and spoke category / total number of items (checked or checked) within that category to give me a percent complete. Does that make sense? The formula i have in the screenshot is for the total percent complete (regardless of task category) and that seemed to work but I cant figure out the percent by category addition!

• Overachievers Alumni

You should be able to do this with a similar structure to what you already have. Something like this should work:

Where the first COUNTIFS is counting anytime Done in the range you defined is checked AND the task category is the category you're looking for (for the example I used Education & Research, but you can change this to whichever category you're looking for).

The denominator is a count of how many tasks fall into your category. In this example how many tasks are Education & Research. That should give you the percentage of tasks checked Done in that category.

• Overachievers Alumni

You should be able to do this with a similar structure to what you already have. Something like this should work:

Where the first COUNTIFS is counting anytime Done in the range you defined is checked AND the task category is the category you're looking for (for the example I used Education & Research, but you can change this to whichever category you're looking for).

The denominator is a count of how many tasks fall into your category. In this example how many tasks are Education & Research. That should give you the percentage of tasks checked Done in that category.

• ✭✭✭✭

@David Tutwiler That did it thank you!

• Overachievers Alumni