How to count checked checkboxes
✓ Verified in LibreOffice 25.8.7.3Total the ticked boxes in a checklist column.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =COUNTIF(A2:A100,TRUE) | Excel checkboxes (Insert → Checkbox, 365) store TRUE/FALSE in the cell. |
| Google Sheets | =COUNTIF(A2:A100,TRUE) | Identical — Sheets checkboxes are TRUE/FALSE cells too. |
| LibreOffice Calc | =COUNTIF(A2:A100,TRUE()) | Same idea; LibreOffice writes booleans as TRUE()/FALSE(). |
How it works
Modern checkboxes are just a checkbox-shaped view of a TRUE/FALSE cell, so COUNTIF with TRUE counts the ticked ones — 2 in the sample. Progress percent is =COUNTIF(A2:A100,TRUE)/COUNTA(A2:A100), and since TRUE sums as 1, =SUMPRODUCT(--A2:A100) counts them too. If your boxes write custom values instead (Sheets lets you set them), count those values instead of TRUE.
Verified, not just documented
We ran =COUNTIF(A2:A4,TRUE()) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 2 — exactly the expected result. Every formula here is confirmed by actually executing it.