ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calculating percentages based on the number of checked boxes in a column (https://www.excelbanter.com/excel-programming/390786-calculating-percentages-based-number-checked-boxes-column.html)

[email protected]

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


Roger Govier

Calculating percentages based on the number of checked boxes in a column
 
see reply to your posting in worksheet.functions



--
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





All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com