In your Google Sheet, you might have checkboxes to know what is done and to be done. Say you want to count the checkboxes in your sheet. Google Sheet allows you to count the checkboxes easily.
2 methods to count checkboxes in Google Sheets
- COUNTIF to count the checked checkboxes
- COUNTIFS to count the checked checkboxes based on a condition
Method 1: COUNTIF to count the checked checkboxes
This is one of the easiest methods to count the checked checkboxes. This method uses the COUNTIF function.
Step 1: Identify the range of cells.
Identify the range of cells with the checkboxes that you want to count. Say you have months and weeks with the status of whether the week’s work was completed.
Here, the range of cells would be C2 to C13.
Step 2: Identify a cell to display the count.
Now, you have to choose the cell you want to display the count. You will also enter the formula in this cell.
Here, cell D4 is chosen to display the count.
Step 3: Enter the formula.
The formula to display the count of checked checkboxes is =COUNTIF(C1:C13, TRUE). The formula has two parameters. The first parameter is the range of cells and the second parameter is the condition. C before the colon represents the start column and 1 represents the start row. C after the colon represents the end column and 13 represents the end row. You use the TRUE condition because whenever you check a checkbox, its value becomes TRUE.
Step 4: Press Enter.
After adding the formula, press Enter to see the formula in action. You can see the count 7 displayed in the cell you’ve entered the formula.
Method 2: COUNTIFS to count the checked checkboxes based on a condition
You can use this method if you want to count the checked checkboxes based on a specific condition. Here, you can use this method to count the checked checkboxes for each month.
Step 1: Identify the range of cells.
You need to identify the range of cells that includes the checkboxes and the data for the condition. Here, the range would be from A2 to A13 and C2 to C13.
Step 2: Identify the cells to display the count.
Choose cells to display the count. You will also enter your formula here. Here, the count of January will be displayed in F2, the count of February in F3, and the count of March in F4.
Step 3: Enter the formula.
COUNTIFS is similar to COUNTIF. The difference is that you can have many conditions in COUNTIFS whereas you can have only one in COUNTIF. The formula to count the checked checkboxes based on a condition is =COUNTIFS(C1:C13, TRUE, A1:A13, E2). There are 4 parameters here.
- The first parameter represents the range of cells with the checkboxes.
- The second parameter represents the condition to check if the checkbox is checked.
- The third parameter represents the range of cells with the data for the condition to be checked.
- The fourth parameter represents the cell with the condition to be checked.
Step 4: Press Enter.
To see the formula in action, press Enter. Cell F2 will display the count of the checked checkboxes in January.
Step 5: Drag the fill handle.
The bottom right corner of the selected cell has a small square. It is called the fill handle.
Drag it across the column to apply the formula.
You’ve applied the formula to the cells present below as well. You can now see the count of the checked checkboxes for each month.
Wrapping up
No more manually counting your checkboxes. You now have two easy methods to count the checkboxes in your Google Sheets.