I want users to fill in boxes with a "Y" to say they have completed pieces of work. When all boxes have a "Y" I want the final cell to read "100%". There are 6 check boxes so each "Y" should be worth 16.7%.

How do I get a "Y" to stand for 16.7%?

My first post on here, I hope someone can help.