| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating percentages based on a single cell | Excel Discussion (Misc queries) | |||
| I want to be able to count the number of checked boxes in a form? | Excel Worksheet Functions | |||
| How do I Calculate Percentages for each number in a column? | Excel Discussion (Misc queries) | |||
| Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
| How do I restrict only 1 of 2 check boxes be checked? | Excel Discussion (Misc queries) | |||
Linear Mode
