Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating percentages based on the number of checked boxes in a column
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating percentages based on the number of checked boxes in a column
Hi Gareth
When you tick the box, the cell you have associated to that box will be set to TRUE. So, if your tick boxes were in cells C1:C8 then =COUNTIF(C1:C8,TRUE)/8 Format the cell with the formula as Percentage. -- Regards Roger Govier wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating percentages based on the number of checked boxes in a column
On Jun 6, 11:23 am, "Roger Govier"
wrote: Hi Gareth When you tick the box, the cell you have associated to that box will be set to TRUE. So, if your tick boxes were in cells C1:C8 then =COUNTIF(C1:C8,TRUE)/8 Format the cell with the formula as Percentage. -- Regards Roger Govier wrote in message oups.com... 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 That's great, many thanks Roger. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating percentages based on the number of checked boxes in a column
On Jun 6, 11:35 am, wrote:
On Jun 6, 11:23 am, "Roger Govier" wrote: Hi Gareth When you tick the box, the cell you have associated to that box will be set to TRUE. So, if your tick boxes were in cells C1:C8 then =COUNTIF(C1:C8,TRUE)/8 Format the cell with the formula as Percentage. -- Regards Roger Govier wrote in message roups.com... 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 That's great, many thanks Roger. Roger - slight problem with this, I don;t think I have associated the boxes with the cells properly, as the percentage doesn't update when I check the boxes. I found some way of attaching it but every time I do this the word TRUE or FALSE appears in the cell behind the box which I don't want. How do I correct this? Thanks Gareth |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating percentages based on the number of checked boxes in a column
On Jun 6, 2:02 pm, wrote:
On Jun 6, 11:35 am, wrote: On Jun 6, 11:23 am, "Roger Govier" wrote: Hi Gareth When you tick the box, the cell you have associated to that box will be set to TRUE. So, if your tick boxes were in cells C1:C8 then =COUNTIF(C1:C8,TRUE)/8 Format the cell with the formula as Percentage. -- Regards Roger Govier wrote in message roups.com... 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 That's great, many thanks Roger. Roger - slight problem with this, I don;t think I have associated the boxes with the cells properly, as the percentage doesn't update when I check the boxes. I found some way of attaching it but every time I do this the word TRUE or FALSE appears in the cell behind the box which I don't want. How do I correct this? Thanks Gareth Ctrl+Click to select rather than activate the control. Double-click and in the Control tab of the dialog box set the proper Cell Link. HTH Kostis Vezerides |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating percentages based on the number of checked boxes in a column
On Jun 6, 12:13 pm, vezerid wrote:
On Jun 6, 2:02 pm, wrote: On Jun 6, 11:35 am, wrote: On Jun 6, 11:23 am, "Roger Govier" wrote: Hi Gareth When you tick the box, the cell you have associated to that box will be set to TRUE. So, if your tick boxes were in cells C1:C8 then =COUNTIF(C1:C8,TRUE)/8 Format the cell with the formula as Percentage. -- Regards Roger Govier wrote in message roups.com... 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 That's great, many thanks Roger. Roger - slight problem with this, I don;t think I have associated the boxes with the cells properly, as the percentage doesn't update when I check the boxes. I found some way of attaching it but every time I do this the word TRUE or FALSE appears in the cell behind the box which I don't want. How do I correct this? Thanks Gareth Ctrl+Click to select rather than activate the control. Double-click and in the Control tab of the dialog box set the proper Cell Link. HTH Kostis Vezerides Thanks Kostis, this will update the percentage but I still get the word TRUE or FALSE appearing in the relevant cell - how do I get rid of this? Also, do I have to associate each box to its cell individually, or is there a quicker way? Thanks Gareth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating percentages based on the number of checked boxes in a column | Excel Discussion (Misc queries) | |||
Calculating percentages based on a single cell | Excel Discussion (Misc queries) | |||
I want to be able to count the number of checked boxes in a form? | Excel Worksheet Functions | |||
How do I Calculate Percentages for each number in a column? | Excel Discussion (Misc queries) | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) |