how to assign a numeric value to a checkmark

[missmac36]

I need help please.....


I would like to have the option to insert a checkmark but I also want to autosum the checkmarks.

I am assuming that I have to assign a numermic value to a checkmark???

 

[jeffreybrown]

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.

 

[VoG]

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

 

[snoopyhr]

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.

 

[shg]

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.

 

[missmac36]

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

 

[missmac36]

Cant thank you enough....greatly appreciated