CODEWITHSUNDEEP
excelpercentage
osomanden
osomanden

Reputation: 611

excel progress percentage done

Stuped my brain here..

    A   B
1   Task1   0%
2   Task2   0%
3   Task3   26%
4   Task4   0%
5   Task5   0%
6   Task6   6%

I need the "progress" on these percentages. Explain: B1 is 0% done. B3 is 26% done. I would like (in row B7) a "Total Progress".

All tasks done is 100% done. But each task is a sub percentage of this. Example gives 32% total. But that is not 32% total progress.

Upvotes: 0

Views: 215

Answers (1)

Patrick Collins
Patrick Collins

Reputation: 4334

Just make the average of the percentages:

=AVERAGE(B1:B7)

Upvotes: 1

Related Questions