Depending on the number of check boxes chosen add them.
Comments

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  PreScreen]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.

What do you get when you do this...
=countif([Phase 1  PreScreen]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  PreScreen]1:[Phase 5  Product Launched], 1) / x
I've attached a screenshot of my formula and an animated gif of it working.

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 lefthand 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

Glad that worked out for you.
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 67 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives