Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting the number of checkboxes on a spreadsheet
Hi all! I have an issue that I have partly resolved that I would like
assistance on. I have a column of checkboxes in a sheet. I would like to have a formula at the bottom that totals the number of checked checkboxes. So far I've had to do a weird way...I go into the Format Control box and link it to a cell and if the box is checked it displays TRUE. Then from there I've got it set to perform a COUNT for those cells that contain TRUE. But the drawback to this is that the word TRUE displays behind the checkbox and I don't want it to. What's the best solution/formula for this?? Thanks in advance, Candice |
#2
|
|||
|
|||
Since the word true does not have any use than to tell you how many
checkboxes are checked you can move the cell link, I usually move it either toi a hidden column or way back to IV, assume the checkboxes are in A2:A50, just change the link location to for instance IV2:IV50 then use =COUNTIF(IV2:IV50,TRUE) If you don't want that large used range you can use any column and then hide it under formatcolumnhide Regards, Peo Sjoblom "Candice H." wrote: Hi all! I have an issue that I have partly resolved that I would like assistance on. I have a column of checkboxes in a sheet. I would like to have a formula at the bottom that totals the number of checked checkboxes. So far I've had to do a weird way...I go into the Format Control box and link it to a cell and if the box is checked it displays TRUE. Then from there I've got it set to perform a COUNT for those cells that contain TRUE. But the drawback to this is that the word TRUE displays behind the checkbox and I don't want it to. What's the best solution/formula for this?? Thanks in advance, Candice |
#3
|
|||
|
|||
Why not link it to a cell off screen, like column IA?
-- HTH Bob Phillips "Candice H." wrote in message ... Hi all! I have an issue that I have partly resolved that I would like assistance on. I have a column of checkboxes in a sheet. I would like to have a formula at the bottom that totals the number of checked checkboxes. So far I've had to do a weird way...I go into the Format Control box and link it to a cell and if the box is checked it displays TRUE. Then from there I've got it set to perform a COUNT for those cells that contain TRUE. But the drawback to this is that the word TRUE displays behind the checkbox and I don't want it to. What's the best solution/formula for this?? Thanks in advance, Candice |
#4
|
|||
|
|||
Another way:
Leave the linked cells where they are and set the font color to be the same as the fill color. Biff "Candice H." wrote in message ... Hi all! I have an issue that I have partly resolved that I would like assistance on. I have a column of checkboxes in a sheet. I would like to have a formula at the bottom that totals the number of checked checkboxes. So far I've had to do a weird way...I go into the Format Control box and link it to a cell and if the box is checked it displays TRUE. Then from there I've got it set to perform a COUNT for those cells that contain TRUE. But the drawback to this is that the word TRUE displays behind the checkbox and I don't want it to. What's the best solution/formula for this?? Thanks in advance, Candice |
#5
|
|||
|
|||
Hi, thanks for replying back. I see that I can total based upon the
true/false that is in each cell, but I have 4 rows of checkboxes. I need a way to fill the checkboxes down and make the cell link relative. So basically I want to total the 4 columns of checkboxes to see which ones are checked. Either code or a formula that I can use to do this without having to do the cell links would be good. Thanks again for helping... "Biff" wrote: Another way: Leave the linked cells where they are and set the font color to be the same as the fill color. Biff "Candice H." wrote in message ... Hi all! I have an issue that I have partly resolved that I would like assistance on. I have a column of checkboxes in a sheet. I would like to have a formula at the bottom that totals the number of checked checkboxes. So far I've had to do a weird way...I go into the Format Control box and link it to a cell and if the box is checked it displays TRUE. Then from there I've got it set to perform a COUNT for those cells that contain TRUE. But the drawback to this is that the word TRUE displays behind the checkbox and I don't want it to. What's the best solution/formula for this?? Thanks in advance, Candice |
#6
|
|||
|
|||
Have 4 columns of checkboxes that I need to total the number of boxes
checked. What would be the best way to do this? "Biff" wrote: Another way: Leave the linked cells where they are and set the font color to be the same as the fill color. Biff "Candice H." wrote in message ... Hi all! I have an issue that I have partly resolved that I would like assistance on. I have a column of checkboxes in a sheet. I would like to have a formula at the bottom that totals the number of checked checkboxes. So far I've had to do a weird way...I go into the Format Control box and link it to a cell and if the box is checked it displays TRUE. Then from there I've got it set to perform a COUNT for those cells that contain TRUE. But the drawback to this is that the word TRUE displays behind the checkbox and I don't want it to. What's the best solution/formula for this?? Thanks in advance, Candice |
#7
|
|||
|
|||
alternative method http://tinyurl.com/a27lw and then just count cells with
an 'a' in them. -- HTH Bob Phillips "Candice H." wrote in message ... Have 4 columns of checkboxes that I need to total the number of boxes checked. What would be the best way to do this? "Biff" wrote: Another way: Leave the linked cells where they are and set the font color to be the same as the fill color. Biff "Candice H." wrote in message ... Hi all! I have an issue that I have partly resolved that I would like assistance on. I have a column of checkboxes in a sheet. I would like to have a formula at the bottom that totals the number of checked checkboxes. So far I've had to do a weird way...I go into the Format Control box and link it to a cell and if the box is checked it displays TRUE. Then from there I've got it set to perform a COUNT for those cells that contain TRUE. But the drawback to this is that the word TRUE displays behind the checkbox and I don't want it to. What's the best solution/formula for this?? Thanks in advance, Candice |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
Create an Auto Number | Excel Worksheet Functions | |||
How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions | |||
multiply by actual number in cell | Excel Worksheet Functions |