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
Hi Gareth
You have an answer in worksheet functions. Please refrain from multiposting. Most of the regulars scan each of the newsgroups so your question will most likely get picked up. It can waste an awful lot of peoples time answering questions, only to find they have already bee answered elsewhere. -- 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 07:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com