?
Solved

Count Check marks

Posted on 2014-01-16
4
Medium Priority
?
368 Views
Last Modified: 2014-03-05
I have a sample sheet attached and I need to count the check marks and get a total. Any assistance would be appreciated!
0
Comment
Question by:Edward Pamias
  • 2
4 Comments
 
LVL 4

Expert Comment

by:Kent Fichtner
ID: 39786010
sorry...not sure if I am blind but I don't see any attached file.
0
 
LVL 19

Author Comment

by:Edward Pamias
ID: 39786017
0
 
LVL 23

Accepted Solution

by:
Danny Child earned 2000 total points
ID: 39786806
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
0;-0;
which surpresses the zero value, just to be tidy.

I also made it a table, as it makes it easier when you insert rows.
EE---tickboxes.xlsx
0
 
LVL 23

Expert Comment

by:Danny Child
ID: 39786810
it also handles upper or lower case codes too...
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question