Completion rate calculator

The correct team completion rate is total completed divided by total assigned, not the average of each project's percentage. Replace the example rows with your own projects, or paste them straight from a spreadsheet.

=SUM(B2:B3)/SUM(C2:C3)
RowABCDRemove
1ProjectDoneTotalRate
2100.0%
30.0%
4Team11010.0%
Your rows stay in this browser only.
Share of tasks actually done
10.0%
What averaging the percentages says
50.0%
Type over any shaded cell, add your own projects, or paste rows from a spreadsheet.Read the guide

Why is averaging percentages wrong?

Averaging percentages gives a one-task project the same weight as a 500-task project. In the example rows, one project is 1 of 1 done and the other is 0 of 9. The average of those rates says 50 percent, yet only 1 of 10 tasks is finished, which is 10 percent.

Can I paste from Excel or Google Sheets?

Yes. Copy three columns (project, done, total) and paste into the first Project cell. A header row is skipped, and rows are added as needed, up to 200. Nothing is uploaded: the sums run in your browser, and your rows are kept in this browser so they're there next time. "Back to the example" clears them.

The SQL version is in Calculate a dashboard completion rate without averaging percentages.

Esc