COUNTA does not count empty cells.
Project complete percentage
To calculate the percentage complete for a project with a list of tasks, you can use a simple formula based on the COUNTA function. In the example shown, the formula in F6 is: =COUNTA(C5:C11)/COUNTA(B5:B11)
