I am using Excel 2007 and want to create a survey form for staff using checkboxes (form controls) and I want to use a countif to count the number of cells which contain a ticked checkbox. eg COUNTIF(C4:C8,TRUE). The results of the countif will determine if they need IT training.

I have worked out how to remove the text which says checkbox1 (next to the checkbox) but I cannot remove the text behind the textbox which says either true or false.

Any suggestions on what I am doing wrong?

Also does anyone have any idea how I can use one spreadsheet which numerous staff can complete - the spreadsheet is going to ask them questions about their IT skills and I want to capture each individuals details and responses - I suspect that the only way to do this is use a database, however I want to produce something that looks similar to a Word document so as not to put off users with little or no IT skills.

I do not have VB skills.


Thanks
Shirl