Project complete percentage

Summary
Explanation
At the core, this formula simply divides tasks complete by the total task count:
=complete/total
which is then formatted as a percentage.
To count complete tasks, we count non-blank cells in the range C5:C11:
=COUNTA(C5:C11)
To count total tasks, we count non-blank cells in the range C5:C11:
COUNTA(B5:B11)
Unlike the COUNT function, which counts only numeric values, COUNTA will count cells that include numbers or text.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.