how to assign a numeric value to a checkmark

jeffreybrown

Well-known Member

Joined

Jul 28, 2004

Messages

5,152

• Mar 13, 2011

• #2

Here is an option for checkmarks...

Alternative to checkboxes Look at Post#5

You could then use a Sumif if this is what you intend.

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Mar 13, 2011

• #3

If you right click a CheckBox and select properties you can select a linked cell. That cell will display True or False. You can coerce that to a numeric value using for example

=N(C1)

Any help

 

Upvote 0

S

snoopyhr

Active Member

Joined

Aug 12, 2002

Messages

395

• Mar 13, 2011

• #4

perhaps there are far better way than this, but this is how I approach the problem...

To get the check mark, I would set a condition as to place Char(256) if condition is true, then format this column to windings. next in the place where you want the sum of check marks, place this formula:

=SUMPRODUCT(--(C1:C159=CHAR(254)))

Assumption is C column is where check marks are.

 

Upvote 0

shg

MrExcel MVP

Joined

May 7, 2008

Messages

21,845

Office Version

1. 2010

Platform

1. Windows

• Mar 13, 2011

• #5

I agree with Jeffrey's suggestion to use Marlett checkboxes, primarily because they are on the data layer of the worksheet. Then you can use a simple COUNTIF formula to tally them.

 

Upvote 0

M

missmac36

New Member

Joined

Mar 13, 2011

Messages

4

• Mar 13, 2011

• #6

Can't thank you enough.... greatly appreciated

 

Upvote 0

M

missmac36

New Member

Joined

Mar 13, 2011

Messages

4

• Mar 13, 2011

• #7

Cant thank you enough....greatly appreciated

 

Upvote 0