Check box = 1
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? |
Check box = 1
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? |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com