View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] gareth.wretham@gmail.com is offline
external usenet poster
 
Posts: 12
Default 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