Excel + Google Sheets · Progress %
Project progress in one cell
Counts finished tasks and divides by the total. Format as %.
The formula
=COUNTIF(B2:B6, "Done") / COUNTA(B2:B6)What each part means
COUNTIF(..., "Done")Finished tasksCOUNTA(B2:B6)All tasks
Example
| A | B | |
|---|---|---|
| 1 | Task | Status |
| 2 | Brief | Done |
| 3 | Design | Done |
| 4 | Copy | Pending |
| 5 | Review | Done |
| 6 | Launch | Pending |
| 7 | Progress |
| A | B | |
|---|---|---|
| 1 | Task | Status |
| 2 | Brief | Done |
| 3 | Design | Done |
| 4 | Copy | Pending |
| 5 | Review | Done |
| 6 | Launch | Pending |
| 7 | Progress | 60% |
Step by step
- Click cell B7.
- Type the formula:
=COUNTIF(B2:B6, "Done") / COUNTA(B2:B6) - Press Enter.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English Progress %
- Español % de avance
- Português % de progresso