ExcelBanter - Forms/ Check Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Forms/ Check Box (https://www.excelbanter.com/excel-discussion-misc-queries/109811-forms-check-box.html)

Gary

Forms/ Check Box

Is there a formula that will calculate the number of check boxes that have
checks in them?
--
Gary

Dave Peterson

Forms/ Check Box

How about assigning a linked cell to each of the checkboxes.

If you put them in a dedicated column, you could use:

=countif(x:x,true)

Gary wrote:

Is there a formula that will calculate the number of check boxes that have
checks in them?
--
Gary

--

Dave Peterson

All times are GMT +1. The time now is 06:41 PM.