Calculating percentages based on the number of checked boxes in a column

's Computer Specifications

I have a column of check boxes which users will check off as they
complete associated tasks.

I want to record a percentage total at the bottom of the column which
reflects the proportion of tasks completed.

Eg if 4 out of the 8 boxes are checked then the "50%" will be
displayed in the relevant cell.

Thanks

's Computer Specifications

see reply to your posting in worksheet.functions

--
Regards

Roger Govier

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a column of check boxes which users will check off as they
> complete associated tasks.
>
> I want to record a percentage total at the bottom of the column which
> reflects the proportion of tasks completed.
>
> Eg if 4 out of the 8 boxes are checked then the "50%" will be
> displayed in the relevant cell.
>
> Thanks
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Calculating percentages of number of occurence of a text value	Jeff Boyce	Microsoft Access Queries	0	5th Jan 2010 01:05 PM
Calculating percentages based on the number of checked boxes in a column	gareth.wretham@gmail.com	Microsoft Excel Worksheet Functions	7	6th Jun 2007 01:08 PM
Calculating percentages based on the number of checked boxes in a column	gareth.wretham@gmail.com	Microsoft Excel Misc	1	6th Jun 2007 12:02 PM
Calculating percentages based on a single cell	=?Utf-8?B?RGltd2l0?=	Microsoft Excel Misc	2	10th Oct 2006 03:14 PM
minimum number of boxes i need checked in the MSCONFIG	Louis	Windows XP Internet Explorer	4	24th Nov 2003 07:56 AM