Question: how do you calculate project completion percentage in excel?
Answer: =COUNTA(C5:C11)/COUNTA(B5:B11) How this formula works. ... 
=complete/total. which is then formatted as a percentage. ... 
=COUNTA(C5:C11) To count total tasks, we count non-blank cells in the range C5:C11:
COUNTA(B5:B11)