View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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