Using formulas to count tick boxes or radio buttons

[Frank Sheeran]

I am sending out a questionnaire to a number of offices and would like to
make it multiple choice and provide tick-boxes or radio buttons. I have been
looking for a formula to verify the "true" condition if ticked and "false" if
not; I cannot find a formula or logical function that will allow me to do
this. Any ideas?

 

[T. Valko]

You'd have to link the checkbox or option button to a cell. Option buttons
return an index number to the linked cell while checkboxes return either
TRUE ot FALSE.

Then you'd do a COUNTIF:

For checkboxes:

=COUNTIF(A1:A10,TRUE)
=COUNTIF(A1:A10,FALSE)

For option buttons:

=COUNTIF(A1:A10,1)
=COUNTIF(A1:A10,2)
etc

 

[Frank Sheeran]

Thanks; that partly answer the question - that's what I tried but got no
value returned as the True\False were not being read. Now I need to know how
to link the tick box to the cell.

Thanks

Frank

 

[T. Valko]

For checkboxes from the Forms toolbar...

Right click on the checkbox
Select Format Control
On the Control tab>Cell link
Enter the cell address: =A1

Follow the same method for option buttons.

 

[Frank]

Thank you; I had to do it in the properties box though, but achieved the same
result.

Frank

 

[T. Valko]

I had to do it in the properties box

Ok, then you're using checkboxes from the Control Toolbox.

Good luck!