+ Reply to Thread
Results 1 to 3 of 3

Calculate Percentage of task completion with Checkboxes

  1. #1
    Registered User
    Join Date
    11-18-2011
    Location
    Colorado Springs, Colorado
    MS-Off Ver
    Excel 2016
    Posts
    17

    Calculate Percentage of task completion with Checkboxes

    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 : %

  2. #2
    Registered User
    Join Date
    11-03-2011
    Location
    Shelton, CT
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Calculate Percentage of task completion with Checkboxes

    Please Login or Register  to view this content.
    Format the cell for % and that will do it
    Last edited by optomyst; 11-18-2011 at 10:36 PM.

  3. #3
    Registered User
    Join Date
    11-18-2011
    Location
    Colorado Springs, Colorado
    MS-Off Ver
    Excel 2016
    Posts
    17

    Re: Calculate Percentage of task completion with Checkboxes

    That formula works partially. If all the boxes next to a task are checked the total is accurate. However, if only some of the boxes are checked the formula returns a faulty value. For instance, I have one milestone that only has two tasks of the five... with both boxes checked it returns a value of 100%.... with only one box checked the value is %200.

    Sorry to be a pain, but I'm stoked that I'm almost there... I'm sure one of you smart folks can help me solve this. Thanks so much for the quick reply as well... I've been up all night trying to get this thing right.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1