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

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum column with count formula	Wally	Microsoft Excel Programming	1	26th Nov 2009 09:46 PM
formula to do a count for info in another column	mike	Microsoft Excel Misc	3	24th Dec 2008 07:00 PM
Specify values for option buttons bound to lookup column	McGeeky	Microsoft Access Forms	6	3rd Dec 2008 08:59 AM
What formula do I use to count if value in other column?	=?Utf-8?B?TG9yaVQ=?=	Microsoft Excel Worksheet Functions	5	15th Nov 2006 07:42 AM
Binding group of option buttons to one Dataset column	shimonsim@talamus.com	Microsoft ADO .NET	2	10th Nov 2003 04:19 AM