Adding a value to OptionButtons
 

Hi

I have problems in getting my options buttons to equal at certain
value. I need this in order to make statistics on how many has selected
one or the other option.

Can anybody help me out in this matter?

Regards

Jan

Adding a value to OptionButtons
 

Hi Jan,

Try:

=COUNTIF(A2:A20,TRUE)

Where A2:A20 is the range of linked cells for the option buttons (check
boxes?).


---
Regards,
Norman


"Hoobes" wrote in message
oups.com...
Hi

I have problems in getting my options buttons to equal at certain
value. I need this in order to make statistics on how many has selected
one or the other option.

Can anybody help me out in this matter?

Regards

Jan

Adding a value to OptionButtons
 

Linked cell property of each optionbutton should be set to a definite cell
in your sheet (say A1,B1, C1)
then enter formula:
=MATCH(TRUE,A1:C1,0)

See example: http://cjoint.com/?fDmBNu5tBz

HTH
--
AP

"Hoobes" a écrit dans le message de news:
...
Hi

I have problems in getting my options buttons to equal at certain
value. I need this in order to make statistics on how many has selected
one or the other option.

Can anybody help me out in this matter?

Regards

Jan