Having a problem, and im new to excel

[samme1988]

to do list, with percentage. but i would like it to change the percentage out of the time it will take to make the tasks. Now it makes 20% for every step even thoe some takes less time and some more time, have used google for a few hours but can't find anything about it, would be really happy for some help

[#2 · Accepted solution]

@samme1988 

=SUMIF(D1:D5,TRUE,A1:A5)/SUM(A1:A5)

=SUMIF(D1:D5,FALSE,A1:A5)/SUM(A1:A5)

You can try these formulas and checkboxes in the attached file.

[#3]

Thank you, that was very helpfull