Site icon The Learning Zone

Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes

Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes
YouTube video player

Microsoft Excel Tips and Tricks

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.

Credit Chester Tugwell

Exit mobile version