How to Count Checkboxes in Google Sheets | Scribe

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
    From the drop-down menu, select the option "Tick box"
    Tick the checkboxes according to your preferences
    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
    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
    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
    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
    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
    Documents you might like
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe