SOLVED

# Having a problem, and im new to excel

Copper Contributor

# Having a problem, and im new to excel

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 Replies
best response confirmed by samme1988 (Copper Contributor)
Solution

# Re: Having a problem, and im new to excel

``=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.

# Re: Having a problem, and im new to excel

Thank you, that was very helpfull
1 best response

Accepted Solutions
best response confirmed by samme1988 (Copper Contributor)
Solution

# Re: Having a problem, and im new to excel

``=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.