![]() |
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 |
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