| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i set up a formula to count option buttons in a column
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Buttons/Radio Buttons | New Users to Excel | |||
| Option buttons: How to get the selected option from a group? | Excel Programming | |||
| Counting selected option buttons in column? | Excel Programming | |||
| Navigating between option buttons is not selecting the option | Excel Programming | |||
| Navigating between option buttons is not selecting the option | Excel Programming | |||
Linear Mode
