I have a project management system I'm working on and need to calculate percentage of task completion based on tasks checked off. I've tried using the formula:
The formula below works, but the problem I run into is not all milestones have five tasks. I need a way to factor in the variable of blank cells. I've done tons of research but nothing seems to apply to my specific situation. This site is great and I really appreciate those of you helping those of us who are technically deficient.
=COUNTA(B5:B9)/5
The cells reflect the following:
A B
Task 1 check box
Task 2 check box
Task 3 check box
Task 4 check box
Task 5 check box
TSK CPLT PERCENT : %
Bookmarks