I hope I understand what you are doing.
How about making the "check" the number 1 and then apply conditional
formatting to colour the cell and text the same colour. Counting that would
be easy. There are other "count" formulae which would do the job but I have
been using a similar method and it also shows graphically how things are
progressing.

You should only need to do one cell and then copy as much as you need.

"Dave" wrote:

I'm pretty out of my depth here, so any help would be much appreciated.

I'm trying to set up an attendance form to cover a 24 hour perid. i'd like a
columnof 14 checkboxes (places available per hour), and at the bottom a total
of how many boxes have been checked, and then repeated for the following 23
columns.

How do i go about giving a cell the value of "1"if the box is checked, and
accumulated the total of checked boxes. I'm struggling to get past changing
"true"/"false" values to "1"/"0" values.

Also, do i have to do this 2352 seperate times (14 places x 24 hours x 7
days a week), or can i do copy and paste?