Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to count checked checkboxes in Excel and Google Sheets
Excel & Google Sheets
=COUNTIF(A2:A4,TRUE)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1In Google Sheets, insert checkboxes via Insert → Checkbox — they default to TRUE (checked) and FALSE (unchecked).
- 2In any empty cell, type =COUNTIF(A2:A100,TRUE) to count all checked boxes in that range.
- 3To count unchecked boxes, use =COUNTIF(A2:A100,FALSE).
- 4In Excel 365, the native checkbox cell also stores TRUE/FALSE, so the same COUNTIF formula works — for older form-control checkboxes, link each to a cell and COUNTIF those linked cells.
Tips
- Use SUMIF instead of COUNTIF to sum values in an adjacent column only where the checkbox is checked: =SUMIF(A2:A10,TRUE,B2:B10).
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Why does my COUNTIF for checkboxes return 0?
Make sure the cells contain actual checkboxes (not typed text 'TRUE'). Insert → Checkbox in Google Sheets creates the correct boolean type.
Can I use COUNTA to count checked checkboxes?
No — COUNTA counts all non-blank cells including unchecked (FALSE) ones. Use COUNTIF(range,TRUE) for checked only.