This guide was created with Scribe in 19 seconds. Sign in and create your own!
How to Count Checkboxes in Google Sheets
Alai Umerez |
0 step |
19 seconds
Select the range where you want to add checkboxes and go to the "Insert" menu in the toolbar
Zoom Saved
From the drop-down menu, select the option "Tick box"
Zoom Saved
Tick the checkboxes according to your preferences
Zoom Saved
Tip!
Keep in mind that ticking a checkbox sets its cell value to **TRUE**, while leaving it unticked sets it to **FALSE**. These values can be easily referenced in formulas elsewhere in the sheet
Choose the cell where you want to display the total count of checked checkboxes
This is where the result of your formula will appear
Zoom Saved
To count the number of unchecked checkboxes in your selected range, use the formula `=COUNTIF(range, TRUE)`
Replace range with the actual range of cells containing the checkboxes
Zoom Saved
Press [[Enter]]
Choose the cell where you want to display the total count of unchecked (empty) checkboxes
This is where the result of your formula will appear
Zoom Saved
To count the number of unchecked checkboxes in your selected range, use the formula `=COUNTIF(range, FALSE)`
Replace range with the actual range of cells containing the checkboxes
Zoom Saved
Press [[Enter]]
Once you press Enter, you'll be able to see the total number of checkboxes that have been ticked as well as the ones that are still empty
Zoom Saved
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key