Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/03/Count-checked-checkboxes.zip

In this Microsoft Excel video tutorial I demonstrate two ways of counting or summing checked checkboxes. The first method uses checkbox controls and is the method to use if you have a small number of checkboxes. The second method uses the CHAR function and a VBA macro; this method is useful if you need a large number of checkboxes.

Both methods use COUNTIF and SUMIF.

Table of Contents:

00:00 - Introduction
00:21 - METHOD 1: Using checkbox controls
03:10 - METHOD 2: Using the CHAR function & VBA
------------------------