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

[gareth.wretham]

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

 

[Roger Govier]

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.

 

[gareth.wretham]

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.

That's great, many thanks Roger.

 

[gareth.wretham]

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

 

[vezerid]

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

 

[gareth.wretham]

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

 

[Roger Govier]

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.

 

[gareth.wretham]

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.

No worries - thanks again.

Regards
Gareth