| 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating percentages based on the number of checked boxes in a column
Hi Gareth
To get rid of TRUE, set the cell font to be the same colour as the background e.g. White on White Unless you use some VBA code for creating the checkboxes, you will have to set the linked cell for each one. With only 8 checkboxes, the manual route is probably quickest. -- Regards Roger Govier wrote in message oups.com... 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating percentages based on the number of checked boxes in a column
On Jun 6, 12:59 pm, "Roger Govier"
wrote: Hi Gareth To get rid of TRUE, set the cell font to be the same colour as the background e.g. White on White Unless you use some VBA code for creating the checkboxes, you will have to set the linked cell for each one. With only 8 checkboxes, the manual route is probably quickest. -- Regards Roger Govier wrote in message oups.com... 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 No worries - thanks again. Regards 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) | |||
Linear Mode
