Solved

Count Check marks

Posted on 2014-01-16
4
311 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 14

Author Comment

by:Edward Pamias
ID: 39786017
0
 
LVL 23

Accepted Solution

by:
Danny Child earned 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Outlook Free & Paid Tools
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now