Check / Tick Boxes

T

tinahumphries

I am using a tick box to indicate whether certain aspects of a job are
complete or not. I would like to create a formula to show me the percentage
of tick boxes complete.
 
D

Dave Peterson

Use a linked cell for each of the checkboxes (say E1:E20 if you have 20
checkboxes.

Then you could use:
=countif(e1:e20,true)/20
format as a percentage

(divided by twenty since I had 20 linked cells for 20 checkboxes.)
 
Top