Count Check marks

I have a sample sheet attached and I need to count the check marks and get a total. Any assistance would be appreciated!
LVL 19
Edward PamiasTeam Lead RRS DeskAsked:
Who is Participating?
Danny ChildConnect With a Mentor IT ManagerCommented:
I don't think you can count the free-form tickboxes in the way that you have inserted them.  However, there is another way, but it needs a "helper" column where you would enter a single letter code for their status (i,o,d), and then a formula builds the tickboxes for you.

Couple of points - table area has to be formatted to use Wingdings font, as that's the one where the Tick and Empty Box symbols are found.

I also added a check for anyone *without* a status, and set a custom format on this cell of
which surpresses the zero value, just to be tidy.

I also made it a table, as it makes it easier when you insert rows.
Kent FichtnerInformation Technology Systems SupervisorCommented:
sorry...not sure if I am blind but I don't see any attached file.
Edward PamiasTeam Lead RRS DeskAuthor Commented:
Danny ChildIT ManagerCommented:
it also handles upper or lower case codes too...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.