How to count checkboxes in Google Sheets

To count checkboxes in Google Sheets, you can use the COUNTIF function in Google Sheets to get the most accurate number of checkboxes according to the data table. Then, users can count the checked checkboxes, or count the unchecked checkboxes. The COUNTIF function is one of the basic functions in Google Sheets, helping you count data according to the content you need. The following article will guide you to count checkboxes in Google Sheets.

1. How to count checkbox cells in Sheets using COUNTIF

The COUNTIF function in Google Sheets counts values ​​in cells based on the criteria you use. The COUNTIF function has a formula of =COUNTIF(range;criteria) .

With the data spreadsheet as shown below in Google Sheets, you first need to identify the data range you want to count the number of checkboxes. First, we will count the number of checkboxes that are checked .

You enter the formula in the cell that writes the result as =COUNTIF(A2:A8;TRUE) and then press Enter .

Immediately after that we will see the result of the number of checked checkboxes is 3 boxes.

To count the number of unchecked checkboxes , enter the formula = COUNTIF (A2: A8; FALSE) and press Enter.

The result also shows the number of cells in the Google Sheets spreadsheet where the checkboxes are not checked.

When we check or uncheck any checkbox, the cell count result will be automatically updated, because we have used the COUNTIF formula in Google Sheets.

How to count checkboxes in Sheets using Validation

When you insert a checkbox in Google Sheets, in addition to using the available Checkbox feature, we can use the Data Validation tool. Then the data for the checkbox is no longer defaulted to TRUE and FALSE, but users can replace it with YES and NO, or any other value.

If you change this value, you can still count checkbox cells using the COUNTIF function easily with the above implementation.

To count the number of checkboxes in COUNTIF, enter the formula = COUNTIF (A1:A8; 'YES') , note that you must use the '' symbol as shown below for the function to recognize the value.

Then press Enter and it will also give the result of the number of checkboxes with a check mark.

Next, you use the COUNTIF function with the same formula when you want to count the number of checkboxes without a check mark. The result also displays the correct number of checkboxes without a check mark.

If you change the checkbox check or uncheck, the cell count result will be automatically updated. So we can apply the COUNTIF function in Google Sheets to count values ​​according to any content.

Video tutorial on counting checkboxes in Google Sheets

Jessica Tanner

Update 22 December 2024