Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/11/Checkboxes.zip

In this video I demonstrate how to add checkboxes or tick-boxes in Google Sheets. In Google Sheets you can easily add checkboxes to multiple cells at once using data validation. The checkbox when ticked returns TRUE and when unticked returns FALSE.

You can apply conditional formatting based on the TRUE and FALSE values and in this video I demonstrate how to change the colour of an entire row when the checkbox within that row is ticked.

I also demonstrate how to perform calculations based on checkboxes:
1) Count the number of checked checkboxes using COUNTIF
2) Sum values based on checked checkboxes using SUMIF

Table of Contents:

00:00 - Intro
00:29 - Add checkboxes in Google Sheets using data validation
00:49 - Apply conditional formatting to an entire row based on the that row's checkbox state
03:25 - Performing calculations based on checkboxes: count and sum
------------------------