✦Template Printable Ideas Insights

Countif Checkbox in Google Sheets: Step-by-Step Guide

By

Ever wished you could count checkboxes in Google Sheets to quickly get a tally of selected options or track task progress? The COUNTIF function is your go-to tool for this. Here's a step-by-step guide on how to use COUNTIF to count checkboxes in Google Sheets.

Before we dive in, ensure your checkboxes are set up as follows: use data validation to create a dropdown list with 'Yes' and 'No' or 'On' and 'Off' options. We'll then use COUNTIF to count the occurrences of 'Yes' or 'On'.

Using COUNTIF to Count Checkboxes

The COUNTIF function counts the number of cells that meet a given criteria. In our case, we'll count the cells that say 'Yes' or 'On'.

How to Insert a Checkbox in Google Sheets
How to Insert a Checkbox in Google Sheets
Count checked boxes, count pending tasks, and show percent complete in minutes
Count checked boxes, count pending tasks, and show percent complete in minutes
Create an Interactive Google Sheets Checklist: Tally Checkboxes, Use Conditional Formatting, and More
Create an Interactive Google Sheets Checklist: Tally Checkboxes, Use Conditional Formatting, and More

Here's the basic syntax: COUNTIF(range, criterion). The range is the set of cells you want to evaluate, and the criterion is the condition those cells must meet (in our case, 'Yes' or 'On').

Count Checkboxes in a Single Column

To count checkboxes in a single column, say Column A (A2:A100), use the following formula in any empty cell:

Google Sheets Checklists
Google Sheets Checklists
How To Create Checklists with Google Sheets
How To Create Checklists with Google Sheets
How to Count the Checked Checkboxes in Google Sheets
How to Count the Checked Checkboxes in Google Sheets

=COUNTIF(A2:A100, "Yes") or =COUNTIF(A2:A100, "On")

This counts the number of cells in the range A2:A100 that contain the text 'Yes' or 'On'.

Count Checkboxes in Multiple Columns

To count checkboxes in multiple columns, say A, B, and C (A2:C100), use the following formula:

Insert a Checkbox in Google Sheets
Insert a Checkbox in Google Sheets
CHECK the Conditional Formatting - Teacher Tech with Alice Keeler
CHECK the Conditional Formatting - Teacher Tech with Alice Keeler
How to insert a checkbox and make it colourful - into Google sheets
How to insert a checkbox and make it colourful - into Google sheets
How to add conditional formatting to checkboxes in Google Sheets. 🤤
How to add conditional formatting to checkboxes in Google Sheets. 🤤
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
Checkbox Hacks in Google Sheets! Easily add conditional formatting when a checkbox is checked + more
Checkbox Hacks in Google Sheets! Easily add conditional formatting when a checkbox is checked + more

=COUNTIF(A2:C100, "Yes") or =COUNTIF(A2:C100, "On")

This counts the number of cells in the range A2:C100 that contain the text 'Yes' or 'On'.

Adding Conditions to COUNTIF

COUNTIF also allows you to add conditions to refine your count. This is handy when you want to count checkboxes based on other criteria.

How to Insert a Checkbox in Excel (In 5 Easy Steps)
How to Insert a Checkbox in Excel (In 5 Easy Steps)
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
Google Sheets - To-do Lists Checkbox
Google Sheets - To-do Lists Checkbox

For example, let's say you want to count 'Yes' responses only from people over 30 years old. In Column D, let's assume you have the age data. The formula would look like this:

=COUNTIFS(A2:A100, "Yes", D2:D100, ">30")

Counting Checkboxes Based on Date

You can also use COUNTIF to count checkboxes based on dates. For instance, let's count 'Yes' responses from the last month. Assuming you have dates in Column E, use:

=COUNTIFS(A2:A100, "Yes", E2:E100, ">TODAY()-30")

This counts the number of 'Yes' responses from the last 30 days.

There you have it! With COUNTIF, you can easily count checkboxes in Google Sheets to quickly get insights and track progress. Happy counting!