Counting Checkboxes

  • Thread starter Thread starter Jeff Hadley
  • Start date Start date
J

Jeff Hadley

I have a spreadsheet which has a column with check box
controls in each row. I need to count the number
of "checked" boxes (true) for a given range. Can someone
assist with a formula to accomplish this?

Thanks
 
Jeff,

From advice given by John McGimpsey previously, assuming forms checkb oxes

'---------------------------------------------
In the Control pane, select a cell (in an out-of-the-way location, say
Z1) in the Cell link refedit box. Do the same for the next checkbox,
using, say cell Z2.

Your count of checked boxes is then

=COUNTIF(Z:Z,TRUE)

Unchecked boxes:

=COUNTIF(Z:Z,FALSE)

If you wish, you can link the cells to a separate sheet and then hide
the sheet.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top