Count Checked and Total Checkboxes in Google Sheets with a Single Formula

Google Sheets provides a simple way to work with checkboxes, which are often used for tasks like tracking progress, marking completed items, or managing to-do lists. If you want to display the number of checked checkboxes alongside the total number of rows containing checkboxes (e.g., 17/133), you can achieve this using a combination of formulas.

Steps to Implement the Solution

Insert Checkboxes in Your Column
- Select the column where you want to insert checkboxes (e.g., Column B).
- Go to the menu bar and click Insert > Checkbox.
- This will populate the selected cells with checkboxes that can be toggled on (TRUE) or off (FALSE).
Add the Formula to Count Checked and Total Checkboxes
- In the cell where you want to display the result (e.g., B1), enter the following formula
```
=COUNTIF(B2:B, TRUE) & "/" & COUNTA(B2:B)
```
- Explanation of the formula:
  - COUNTIF(B2:B, TRUE): Counts the number of checkboxes that are checked (TRUE).
  - COUNTA(B2:B): Counts the total number of rows in the column that contain checkboxes (non-empty cells).
  - & "/" &: Combines the two results into a single string separated by a /.
Adjust the Range
- If your checkboxes start in a different row (e.g., B3) or span a specific range (e.g., B3:B50), adjust the formula accordingly
```
=COUNTIF(B3:B50, TRUE) & "/" & COUNTA(B3:B50)
```
- For a dynamic range that automatically adjusts as you add more checkboxes, use an open-ended range like B2:B
```
=COUNTIF(B2:B, TRUE) & "/" & COUNTA(B2:B)
```
Format the Result
- The formula will display the result in the format Checked/Total (e.g., 17/133).
- You can place this formula at the top of your column (e.g., B1) for easy visibility.

Tips and Best Practices

Dynamic Ranges: Use an open-ended range like B2:B to ensure the formula updates automatically as you add or remove checkboxes.
Avoid Blank Rows: Ensure there are no unintended blank rows within your checkbox range, as they may affect the total count.
Header Row: Place the formula above your checkbox range (e.g., in the header row) to keep it organized and easily accessible.