View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default How can i set up a formula to count option buttons in a column

Option buttons from the control toolbox toolbar?

You can link them to the cells underneath and then use countif against that
column to count the number of cells that contain True.

--
Regards,
Tom Ogilvy



"Lewis" wrote:

I am trying to get a form set up that has 55 questions with 3 possible
answers. I am using option option buttons (3 buttons/question) arranged in 3
columns. Is there a way (function, formula, macro) that will give me a total
number of option buttons chosen for each column?