How can i set up a formula to count option buttons in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Mid column sum formulas with varied ranges to sum 17
macro to select option button in option group 2
Cell Count Between Value 13
Sorting Columns with a Formula 1
Hiding option buttons 3
Excel A CountIF question... I think 2
Multipage (wizard) 6

Back
Top