+ Reply to Thread
Results 1 to 2 of 2

Percentage Completed with Checkboxes....

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

    Percentage Completed with Checkboxes....

    Alright, I'm almost there, but I need some help. I have a spread sheet of some task milestones and I want to use check boxes to tick off completed tasks and then have a cell at the bottom that calculates the percentage of completed tasks against those not completed.

    I used the formula below which works, sort of.. but it only adds 10% for every task checked off. I want to be able to add or delete tasks and have it impact the completed percentage. Can someone help me? Thanks in advance.

    =COUNTA(B5:B10)/COLUMNS(B5:B10)/10

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Percentage Completed with Checkboxes....

    To best illustrate what you desire, can you attach a sample workbook with what you have and what you want?
    HTH
    Regards, Jeff

+ 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