Forum Discussion
samme1988
Apr 22, 2023Copper 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
=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.
2 Replies
Sort By
- OliverScheurichGold Contributor
=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.
- samme1988Copper ContributorThank you, that was very helpfull