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)