Depending on the number of check boxes chosen add them.

I have 5 columns with Checkboxes and one with % Complete, I need the %column to show the values added up depending on the number of check boxes chosen, so if there are 3 checked boxes, it should show 60% complete. Can you help? Thanks

See screen shot attached

% Complete.PNG


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Format the completed column as percentages and use the following formula which counts each column if it's checked and then divides it by 5 which is the possible number of answers. 

    =countif([Phase 1 - Pre-Screen]1:[Phase 5 - Product Launched], 1)/5


  • It does not seem to give a "20%" value on each of the columns that are checked, these should add up to a 100% if all were checked. when I remove a check the % complete should change as well, but it does not. 

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    What do you get when you do this... 

    =countif([Phase 1 - Pre-Screen]1:[Phase 5 - Product Launched], 1)

    Does that number change based on how many you click?

    When you have them all clicked what is the final number? 

    When you have that number replace x in this formula with that number. 

    =countif([Phase 1 - Pre-Screen]1:[Phase 5 - Product Launched], 1) / x

    I've attached a screenshot of my formula and an animated gif of it working. 



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    If you are seeing a decimal number... .02, .04, .06, .08 or 1 its because you haven't formatted that cell or column as a percentage. Do that by highlighting the column and clicking the % sign in the left-hand toolbar. 

  • Hi Mike, yup that worked, I gues after building and rebuilding formulas over and over in the same cell you need to clear it out and delete it. Then start over and not copy and paste but type it out and it worked. Thanks Bro

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Glad that worked out for you.