If you have found this content useful and want to show your appreciation, please use this link to buy me a beer .
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you!
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
————————

Please take the opportunity to connect and share this video with your friends and family if you find it useful.