In this tutorial, you will learn how to sum checkboxes in Google Sheets
How To Sum Checkboxes in Google Sheets
Quick Navigation
Checkboxes are a great data validation feature that allows users to easily toggle the value of a cell with a single click.
If you’re working with checkboxes in Google Sheets, you may find yourself needing to count the number of checkboxes that are checked or unchecked.
For example, if you’re tracking tasks, you may want to have a view of the number of completed or pending tasks. Since checkboxes are just a visual element that represents either a TRUE or FALSE value, we can use a formula like COUNTIF to check how many checkboxes hold one of these two values.
In this guide, we will show you how to use the COUNTIF function to count the number of checkboxes in Google Sheets.
How to Count the Number of Checkboxes in Google Sheets.
Here’s how to count the number of selected checkboxes in Google Sheets.
Step 1
First, select the cell that will hold the count of all checkboxes of a given state,
In this example, we have an employee tracker with a column that keeps track of which employees have been onboarded. We want to count the number of checked checkboxes in column G and output the result in cell I2.
Step 2
Type the formula “=COUNTIF(“ to start the COUNTIF function.
The COUNTIF function allows users to count the number of cells in a range meet a particular criteria.
Step 3
The COUNTIF function’s first argument indicates the cell range that will be counted on.
In this case, we’ve selected the range G2:G21.
Step 4
The second argument of the COUNTIF function refers to the criteria to use when considering what values to count. In this case, we want to count all values in range G2:G21 that are equal to TRUE.
Step 5
Hit the Enter key to evaluate the COUNTIF function.
In this example, we’ve determined that there are 10 employees who have already been onboarded.
Step 6
What if you need to find the count of all unchecked cells? We can use the value FALSE as our criteria.
Setting the criteria to FALSE will ensure that the formula will only count unchecked checkboxes in the provided range.
Summary
This guide should be everything you need to count the number of checkboxes in a range in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.