Checkboxes

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I've added a checkbox from the "Forms" toolbar to a
spreadsheet I am working on. When checked by the user, I
would like one day added to the date listed in the column
before it then returned in the column after it.

Example:

1/1/04 (no check) 1/1/04
1/1/04 (checked) 1/2/04

How can I create a formula that calculates the total
number of checked check boxes on a spreadsheet?

Thanks for the help!

Matt
 
One way

=COUNTIF(Range,TRUE)

where Range is the range with the linked cells, if you are smart you would
make
that range contiguous
 
Thank you for the advice. I haven't really worked with
linking checkboxes to cells. The spreadsheet that I am
working on prevents me from setting the range
contiguously. This is going to present a problem isn't
it?
Is there a way to do it without having to link the cells
to the checkbox. If not, am I thinking correctly that
the cells that hold the values of the checkbox
(true/false) should be hidden since they serve no
practical purpose when visible?

Any luck with my other question about having a small
formula execute when a checkbox is checked???

thanks for the advice and help,
Matt
 
Matt,
even if the checkboxes are not contiguous
the linked cells can be. Right click a checkbox,
select format control, click control and put the link there
Repeat for the other check boxes and use the countif formula
Regarding the formula executing when a box is checked.

Assume the first check box is linked to Sheet2!$A$1

then you can use a formula like this

=IF(Sheet2!$A$1=FALSE,"",your_formula))

meaning cell is blank if the check box is unchecked but when checked it will
return the formula. Using real cell addresses it can look like

=IF(Sheet2!$A$1=FALSE,"",SUM($A$3:$A$10))
 
Back
Top