How to create Checklist in Excel 2010
Now we are going to learn about how to create Checklist in Excel 2010.
Check Box in Microsoft Excel 2010
In this article we will create checklist in Excel 2010. Firstly we will take some list of name. Then click on developer and then drag down Checkbox in b2 cell then drag checkbox to insert option.
After that Check box will come in the B2 cell then select the B2 cell and drag it down right lower corner of the list.
Now right click on the Top of the check box. Then go to the format control.
Link the checkbox to the cell next to it mean C2. This condition apply all the check box.
Now countif formula use for given below.