View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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