Adding Percentages

Question

Hi all,

I have a spreadsheet listing a number of header tasks and subtasks.

I have the header tasks showing percentage of subtasks completed.

=Countif(i8:i10,"complete")/counta(i8:i10)

I have this formula on a number of rows in my worksheet.

However, the header tasks are now also grouped by an overall "Theme" of the work. So one theme may have 3 header tasks and each has 4 subtasks for example.

How do I display the overall percentage of subtasks marked as complete? It won't allow me to have multiple ranges so I can't just look straight down the list as it would include the header tasks which should not be counted.

Thanks

Answer 1

Hi,

The way I've got it set currently is using countif formula. This gives me the percentage each task is complete.

So if a task has 3 subtasks, the formula counts the task if its marked as complete, then divides by the number of tasks.

Thanks

Answer 2

You're going to need to include the numbers associated with those percentages since the solution is dependent on the actual numbers and not the percentages. Percentages can be calculated from the actual numbers, but you cannot calculate how much a percentage of a value has increased or reduced based on the overall percentage. Hence your data set is lacking and impossible to resolve.

Answer 3

Hi, im hoping it will be something along the lines of this:

Header Task A	Ongoing	50%
Task	Ongoing	50%
Sub task	Completed	100%
Sub Task	Not started	0%
Header Task B	Ongoing	75%
Task	Ongoing	75%
Sub task	Completed	50%
Sub task	Ongoing	100%
Task		75%
Sub task	Ongoing	50%
Sub task	Completed	100%

Answer 4

Hi Daniel,

Thank you for querying in this forum.

To better understand the situation on your side, could you please share some screenshots about "the header tasks are now also grouped by an overall "Theme" of the work. So one theme may have 3 header tasks and each has 4 subtasks for example. "?

We appreciate your patience and effort.

Best regards,

Tina