View Single Post
  #1   Report Post  
Candice H.
 
Posts: n/a
Default 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