Forum Discussion
Solved
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...
=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.
=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.
- Thank you, that was very helpfull
