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

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

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